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.
