Re: Access File location Problem on deployment

Hello Thomas,

I already posted in the newsgroup deployment but still there is
a problem. Adoconnection at designtime works perfectly.
When I want to install the program after compiling with Innosetup, there
is a windows message that the mdb files are not found at .... some path on
the computer...
in the beginning it was 'Documents and settings/Allusers/' or something
like this, sometimes it is
c:\program \dbfiles\TED\DBFiles\'.

Don't put your data files in there, on Vista, applications are not allowed
to write
to files in there.

(TED being the applicationname, DBFiles the name of the subfolder being
the storage location of the mdb files , but I don't create and copy this
folder because if files are searched in the 'doument and Settings' path,
anyway this folder will not exist}
I read out the special folder constant "clrid_common_documents" from the
shfolder uses but it is not there where my mdb files are searched.... Also
this seems to change from win XP home to winXP Pro...

If there is something not clear have a look at my newest post at
'deployment' please where I put also the code.
Anybody know what happens ?

Make sure to create your InnoSetup script so, that is deploys your MDB file
into the user data folder.

Next, use the ShellFolder stuff to make sure your ADOConnection uses that
file instead of some subdirectory from the "current directory".


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


.

Relevant Pages

  • Re: setting a password
    ... In the search results, just go to Tools, Folder Options. ... Uncheck 'Hide extensions for known file types', then click on Apply to All ... Microsoft Access MVP ... If you can't find the mdb files, you can always use Start, Search, ...
    (microsoft.public.access.security)
  • RE: Append Query Unable To Display Link List Tables
    ... I tested my mdb files on another computer & the append query works. ... All the mdb files I am trying to work with are in the same folder. ... When I browse and open the correct database, there is no list of tables--it ...
    (microsoft.public.access.queries)
  • Re: my doc redirection
    ... with doc redirect. ... A user with a laptop created 3 .mdb files while connected ... files were uploaded to the user folder on the server. ...
    (microsoft.public.windows.server.sbs)
  • Re: How do I backuo and copy Access data
    ... >access the mapped drive in Windows Explorer or use ... >> folder in another computer to work with the same data ... >> two different PCs. ... >> advised to copy them from MDB files. ...
    (microsoft.public.access.gettingstarted)
  • Re: File copy for daily backups
    ... I have a folder which contains two files, both access .mdb files. ... Set fso = CreateObject ...
    (microsoft.public.scripting.vbscript)