Multi-User Problem

  • Thread starter Thread starter Cathy
  • Start date Start date
C

Cathy

I created a multi-user Access 2000 database that has been
placed on a NT LAN drive. Every once in a while, a user
gets in there and the database locks everyone else out
with an error message that the database is no longer a
database, then a second message saying that user XXX has
exclusive use. I've talked to the users, and they are not
entering as exclusive. They tend to be Managers and
Directors in the company... but other than that, there
doesn't seem to be anything they share in common. How can
I prevent this error from occuring in the future?
Thanks!
Cathy
 
Cathy,
does your application hide the database window?
In the list of your users do you have any "dangerous" user who would have
any intension to open table from the database window directly?
Are you using the "split" design: front end separate from the back end?
 
I do have the database hidden. I doubt anyone who is
having this problem would know how to open the database
window directly. This is not a split design.

Any ideas on how to fix?

Thanks,
Cathy
 
Hi Cathy,

Ensure that all users of the database have modify permissions on the folder
where the database is.

In addition, you'd be wise to split the database into frontend/backend (the
backend sits on the server and contains just the tables, a copy of the
frontend linked to the backend is put on each user's computer. The frontend
contains all objects except the tables).
 
Back
Top