In any well developed MS Access database, it becomes necessary to automate the relinking of the back-end database tables. If nothing more than to simplify switching between Development and Production environments.
There are any number of existing resources that you can very rapidly implement.
Below are a few useful links with VBA code samples of how to relink linked-tables through automation:
- Relink Access tables from code
- Relink ODBC tables from code
- Relink tables from different datasources
In complexe database setups, it may become necessary to relink your database to multiple back-ends. I started out writting my own code to do this and then came accross nice sample from David Fenton Associates:
Another good one is the J Street Relinker:
Hopefully these links will save you some time searching the net.
Will any of the above work with a 2013 Runtime version to be sent to a client where I am not aware of the server name or path?
Thank you,
I think I’ve use most, if not all of them, at one point in time and I don’t recall ever having any issues with them.