Multi-User Problem

[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

 

[Glen SIdelnikov]

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?

 

[Cathy]

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

 

[Joan Wild]

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).