When sharing an Access database, you should have the data in one file (the back end) and the queries, reports, forms and modules in a separate database (the front end).

Give each user their own copy of the front end, linked to the shared back end.

Keep a master copy of the front end file, [...]