Prompt to update linked table location in VBA
I have a database with a linked table for the backend. When I open the database and the location to the backend can't be found the program errors out. Is there a way to get it to prompt me so I can tell it where the database is without having to go into the linked table manager?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I know this is already answered, but here's another alternative that doesn't require any additional code. You're welcome to use our free J Street Access Relinker on our J Street Downloads page: http://ow.ly/M56Q
It's some simple code that you copy into your front-end application. It handles multiple Access back-end databases, ignores non-Access tables, and can automatically and silently relink to back-end databases in the same folder as the application (handy for work databases or single-user scenarios). There's a ReadMe table with instructions.
Cheers,
Armen
It's some simple code that you copy into your front-end application. It handles multiple Access back-end databases, ignores non-Access tables, and can automatically and silently relink to back-end databases in the same folder as the application (handy for work databases or single-user scenarios). There's a ReadMe table with instructions.
Cheers,
Armen
ASKER
Posted solution I found in a different thread.
http://www.mvps.org/access/tables/tbl0009.htm
Note that you need to get other code as well, as is indicated in the intro.