Avatar of Murray Brown
Murray Brown
Flag 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?
Microsoft AccessVBA

Avatar of undefined
Last Comment
Dale Fye

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Daniel Pineault

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Murray Brown

ASKER
thanks very much
Dale Fye

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.  


Your help has saved me hundreds of hours of internet surfing.
fblack61