Relinking Multiple Tables at Startup

[KornGeek]

I have my Access 2000 database split into a front-end and a back-end. In addition to the back-end, it also has links to about five other tables as well. I used Microsoft's sample database and a little bit of creativity to get it to re-link the back-end database on startup. However, I'm not sure how to get it to re-link the other tables. Does anybody have any suggestions and/or sample code that might help me with this?

Unfortunately, I can't necessarily assume that these temporary tables will be in the same directory as the back-end.

I appreciate any help you might be able to give.

 

[cmmrfrds]

Check the Microsoft site for an example.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office10052000.asp

 

[KornGeek]

I was able to get this working because of some application-specific rules. The temporary tables will always reside in the same directory as the front-end, and the names I used for the temporary table in Access all end in "Temp". This made it easy for me to determine in my code if I was dealing with one of these tables.

I then modified the Microsoft code to work in two passes. The first relinks the back-end and allows the user to select the destination if it is not found. The second pass relinks the temporary tables and requires no user input. It simply looks at the current path of the database and uses that.