The correct way to setup a system is to split the database and have one frontend for each user sharing a common backend on a server. That way there will only be one user in each of the frontends at any one time and that frontend can shut down when idle.
Basically, all tables go in the backend on the server and everything else is duplicated in each frontend. Do a search on this site for splitting a database.