Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access VBA automaticcally relink to backend database when split database solution is copied to other machines

Hi
I have an Access database with linked tables in another Access file that is in the same folder called "Backend1.accdb".
When I distribute the Access database I want to automatically loop through and relink the tables to the new location of the backend
which will always be in the same folder as the current database. What VBA code would I use?
ASKER CERTIFIED SOLUTION
Avatar of Daniel Pineault
Daniel Pineault

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

ASKER

thanks very much

Murray,


Durring development, it's OK to have the FE and BE in the same folder, preferably on your PC, or you can put the FE on your computer and the BE on a network file server.  But when you deploy the application, every user should have their own copy of the FE of the split database, on their PC.  The BE should be on a network file server, and when you link the FE to the BE, you should use the fully qualified network name:


\\ServerName\Folder\folder\appname_be.accdb


as the path.  That way, when you copy the FE to each users computer, you will not have to worry about them having the wrong drive name mapped to a particular letter.