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

[Maya16]

Hi..
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.

[Seth Schrock]

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.