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

Could not lock file in Ms Access

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.
0
imaksu
Asked:
imaksu
1 Solution
 
Sander StadSysteemontwikkelaar, Database AdministratorCommented:
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.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
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

Protect Your Employees from Wi-Fi Threats

As Wi-Fi growth and popularity continues to climb, not everyone understands the risks that come with connecting to public Wi-Fi or even offering Wi-Fi to employees, visitors and guests. Download the resource kit to make sure your safe wherever business takes you!

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