Change Backend location.

[pekajo]

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]

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]

jstreet relinker

Developer Downloads - J Street Technology

These free developer downloads are for our fellow developers – we hope you find them useful! If you use a download for commercial purposes all we ask is that you keep the J Street Technology references in the code. Are you stuck on your project? Need help with development? For mentoring and...

www.jstreettech.com

 

[MajP]

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.