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!
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
What are the steps to fix damaged MDF files in SQL Server? 0
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
Which is the best MBOX Converter Tool different formats conversion? 4
Best tool to recover PST files in 2026 0
How can we convert OST to PDF file format? 1
Best Tool to Repair Corrupted PDF Files 0
What do you use your R-Pi for - which Projects are you planning!? 1

Back
Top