once designed and functional,
put the db on a network folder, split the db.
the backend (BE) tables stay on the network,
each user will get a copy of the Front End, in their personal folder.
I have a table tUsers, with eveyones userID and folder path.
I can click a button to copy the FE to all users in the list, in order to distribute updates to all.
(if needed) It also serves as the validation list of who's allowed in the app