My name is Roger, we are 3 guys who have recently developing a CMMS application for Wind Industry in Quebec, Canada.
We have to make our «multiuser single site Access Application» become multisite. We made it with Microsoft Access 2010. It is installed in Terminal Server so each user opens his own front end but share the back end (data) with others. We are not sure how to accomplish this transition. We are expecting to have to rewrite our queries so the user will determine at logon from witch he is and witch records are his... At the same time, it will be a huge job that we would we would like to avoid doing. We want to keep only one database for all sites because we find it easier to maintain or to apply changes. Some data is shared by everyone and other isn't.
Is there any method that would make it possible to isolate data for each individual site at login (in the access app.) so we wouldn't have to modify the code and the queries?
Thanks in advance