Change Backend location. (1 Viewer)

pekajo

Registered User.
Local time
Tomorrow, 00:31
Joined
Jul 25, 2011
Messages
132
Hi,
I have designed a ms access database for a community centers. It works well but I would like to split and have a backend.
However a number of community houses have different drives which is ok with just one database. My thinking was having having a table with the backend location for each site. Is it possible to use VBA to 'reset' the backend link by just clicking a button.
So when a site gets a new frontend they will need to click this button to reset the backend location.
Thanks for any help.
Peter
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:31
Joined
Oct 29, 2018
Messages
21,357
Hi Peter. Yes, you can link to a different backend using VBA. There are several sample code for doing just that. If I find a link, I'll post it here.

Sent from phone...
 

moke123

AWF VIP
Local time
Today, 09:31
Joined
Jan 11, 2013
Messages
3,849
jstreet relinker
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 09:31
Joined
May 21, 2018
Messages
8,463
Here is all the code you need. All you have to do is make frmLink the default form and change the name of the form to open. You need a reference to office for the file dialog. It will prompt you for the folder if it cannot find it.
 

Attachments

  • FrontEnd.zip
    331.9 KB · Views: 302

Users who are viewing this thread

Top Bottom