users locked out

  • Thread starter Thread starter snoopsmom
  • Start date Start date
S

snoopsmom

We have a database which 3 people use on their own PCs.
All three users have Windows 2000 and Access 97. Users A
and B can be in the database at the same time, no matter
which one opens it first. However, user C can't get in if
either A or B is in, nor can A or B get in if user C has
it open. What's going on, and how can I correct this?
Thanks in advance.
 
This is likely a network rights issue. All of the users must have ALL
rights to the DIRECTORY where the database is sitting. What is happening is
the users do not have CREATE rights to the directory. Without that, the LDB
file cannot be created. Without the locking file, Access thinks it has been
opened exclusively, so only one person can open it at a time.
 
Duh...! The user had rights to the FILE, but not the
Directory...everything OK now..Thanks!
 
Back
Top