access: start parameters

[Phaedros]

hello,
is it possible to specify more than one data storage paths for access? i tried it (semicolon separation , space etc.) but nothing worked.

hints welcome,
phaedros (user)

 

[PHV]

specify more than one data storage paths for access
???
What do you want to do ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Phaedros]

microsoft access allows to specify a default path, where user data are stored generally. this is done in the ini-file, e.g. as "C:\programs\access\data\my_data".

i would like to specify a second path, to have a choice later in the context menu, pointing to a backup drive for instance.

hope this time it's less ambiguous,

phaedros

 

[RandyMyers]

I would think the best solution is to use linked tables. Then you could just use link table manager to redirect to another set of tables. I do this all the time. This would work with standard Jet Engine tables but is more efficiently accomplished by using ODBC. You can have multiple ODBCs setup, point to the various data backups. In link table manager just select all tables and check Always Prompt For a New Location. The specify another ODBC and all is compete.