• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1442
  • Last Modified:

Could not lock file

I get this error, 'could not lock file', when i try to open the database.  It is on a network in shared mode but
security has not yet been implemented.  Any suggestions?
0
BBrian
Asked:
BBrian
1 Solution
 
xtrahandsCommented:
What are you trying to do when you get the error?

It may be that you are trying something that requires exclusive access to the database and someone else is using it.

0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Make sure that you have full read/write/delete priviledges for the directory where the MDB resides.

If you don't, Access will have trouble creating the .LDB file used to track locks.

Jim.
0
 
BBrianAuthor Commented:
I think that's it.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
If it's not, bounce back and we can keep working on it.  Also, in the future, you may not want to accept an answer until your sure the problem is solved.

Jim.
0
 
BBrianAuthor Commented:
I have been having permission problems with
the directory in question anyway.  Sometimes I get 'could  not lock file' and sometimes I can only open the
datbase read-only.  And sure enough when I checked
the folder in question, there were no write permssions.

Thank you for your feed back.
0
 
chansonpeevyCommented:
i have the same error when my clients try to access the DB. parent folder security has been resolved. still getting the "cannot lock file" error. i try and go into the security properties of the .ldb file, and it sais i have no permission to view the security properties. anyone see this one?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now