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?
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
Last Comment
Dale Fye
ASKER CERTIFIED SOLUTION
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
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 questionASKER
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.
Your help has saved me hundreds of hours of internet surfing.
fblack61