I have setup a simple retail system consisting of a local SQL Server (Express) back-end and an Access front-end which works very well. The front-end also consists of an 'admin' form to edit various system settings / client data etc.
There is in fact now 7 identical systems in place and I have a need to add the facility for the admin form to be used at one (central) location to update settings for one or more of the remote locations as required.
I'd like to add a dropdown to the admin form, from where a location can be selected and then the form will allow editing of that location's data. I'm fine with setting up remote access to sql server tables / router ports etc. but not sure of the best way to implement the location selection without having 7 identical forms, each linked to the different location's tables.
Is there a way to link different tables via code so the dropdown selection would run a subroutine to perform the table linking and enable the same admin form to then update a particular location? I guess I could link all the tables to the Access db in the first place then just change the recordsource of each form/subform required as one solution?
Hope that makes sense, any other ideas / suggestions welcome.