"Could Not Lock File"

G

Guest

In workgroup when trying to access the database on another computer [WinXP]
get "could not lock file" message so am unable to get into the database.
Please Help.
Joan
 
D

Douglas J. Steele

1) Are you perhaps trying to open it Exclusively, and someone else is
already in it? Check the Advanced tab under Tools | Options and make sure
that the Default Open Mode is set to Shared.

2) What permission do you have on the folder where the MDB exists? You need
Change (Read, Write, eXecute, Delete), even if you're only trying to open
the database read-only. This is because Access needs to be able to create a
locking file (.LDB) in the same folder as the .MDB file.
 

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

Top