Just guessing, given the scant information you've provided, but it sounds
like you have a single mdb on a server with multiple users using it at the
same time.
You should split the database and leave the backend (tables/relationships
only) on the server, and give each user a copy of the frontend (all other
objects) on their PC. The frontend would contain linked tables connected to
the backend.
There is a database splitter wizard to help you do this. - tools database
utilities.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.