By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,255 Members | 2,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,255 IT Pros & Developers. It's quick & easy.

Linking issue to database while moving application from one dir to another dir

P: 7
I am new to VBA access. I have created one application using VBA Access. I split the database from "database tools -> Access Database", and linked it through the "Database Tools -> Linked table Manager". It works fine. Both the application and Database are in the same folder.But when I move that folder from one directory to another directory it does not linked to that database automatically. I again have to linked it to the database through "Linked Table Manager". Is there any solution that my database will automatically link to the application.
Dec 18 '13 #1
Share this Question
Share on Google+
1 Reply

Seth Schrock
Expert 2.5K+
P: 2,941
As far as I'm aware, when linking to a separate backend, it doesn't get the location based on its proximity to the frontend. It uses its actual location on the computer so if you change the location of the backend at all, it will break the link. Here is an article that describes how to prompt for the new backend location (look at the second post): Relinking ODBC Tables using VBA. You may also look at Is it possible to store the location of the backend database in a table which is when I learned how to relink tables. What I ended up doing is to test if I could get into one of the tables that was in the backend and then if I couldn't then I would prompt for the new location.
Dec 18 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.