[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Could not lock file in Ms Access

Posted on 2008-11-19
Medium Priority
Last Modified: 2013-12-04
Using Ms Access 2003 created an mdb file, put it on a folder on the server. When trying to open the mdb from a client who has full control authority to the shared folder we get "Could not lock file" Using Windows 2003 Server sw, Windows XP and Vista on clients.
Question by:imaksu

Accepted Solution

Sander Stad earned 100 total points
ID: 22992622
The problem is that the user can't lock the .ldb file. You say you hev given people the Full Control Share permission. You also have to set the read-write permission on the NTFS level that's where you're problem resides.
The shared folder permissions should always be put on full control and you should set the actual permission in the securitytab.
LVL 85
ID: 22993116
Also make sure your permissions are inheritable by the files you place in this folder.

Also, you should provide for EVERY user a COPY of the database, and not allow them to share it. If you allow users to share, then one user can lock everyone out. IOW, split the database, place the Backend (Tables only) on the server, and deploy a FrontEnd (everything else) to each user.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question