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
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