How to connect to another copy of the same data bae

[PercyN]

I have a program that I have split. It works fine because I dont have to move the BE (yet). If I ever do move the BE to another location or to a different server or for some reason I need to connect to another copy (e.g. backup copy) of the same data base, how do I go about?

 

[Remou]

You will find instructions for manually relinking the tables here:

http://office.microsoft.com/en-us/a...d-path-for-linked-tables-mdb-HP005187623.aspx

BTW, forum700 would be a good place to post similar questions.

http://lessthandot.com

 

[PercyN]

Thanks Remou, this was very helpful but I actually want to do this in code, so that end users can connect to a backup copy for instance of the data base by simply specify the location of the new db.

 

[Remou]

There is full code here for an Access be:

http://support.microsoft.com/kb/181076

I prefer to keep a "table of tables" rather than just relink everything in the be. I use a start-up form that checks against the table of tables and if anything is wrong, attempts to correct it or opens the relink form, otherwise, opens the menu. A table of tables is also useful if your be is something other than Access. Tables vcan also be relinked through ADOX and / or VBScript.

Tony Toews also has an example

http://www.granite.ab.ca/access/relinkingtables.htm,

as, I am sure, do other Access MVPs.

A search of tek-tips returns a number of threads.

http://lessthandot.com