I have a project with 2 accdb. The MASTER contains forms, reports etc. The DATA accdb contains only tables which is password protected. The tables in the master accdb has links to all tables to the data accdb. This setup allows me to revise program codes, add forms/reports easily by just create the links manually. However, this also create a problem: if user accidentally changes the name of the folder containing the DATA accdd, the link path is invalid. By design both accdb are in the same folder.
I want to add some codes such that when the startup form is loaded, it checks the links. If the path is invalid, it rebuilds the links by looking into the folder the MASTER accdb is. I know this will not prevent the error if user move one of the accdb to other folder but this is not considered.
Thanks for your advice.
I want to add some codes such that when the startup form is loaded, it checks the links. If the path is invalid, it rebuilds the links by looking into the folder the MASTER accdb is. I know this will not prevent the error if user move one of the accdb to other folder but this is not considered.
Thanks for your advice.