could not lock file

[Linda B]

Hello,

I have a user who has an MDE database on the network
accessed by many other users. When a handful of users
tries to open the database they get an error that
states "Could not lock file". However, the vast majority
of people can open the database just fine.

Is there some setting I'm missing somewhere? Can anyone
tell me why this error is happening? Thank you.

-LB

 

[Rick B]

I'm betting that those users do not have "write" permissions to the lan
folder in which the file lives. this is preventing them from updating the
ldb file.

I would, however, expect it to open the file as read-only for those users,
so I could be wrong in my assumption.

Rick B



Hello,

I have a user who has an MDE database on the network
accessed by many other users. When a handful of users
tries to open the database they get an error that
states "Could not lock file". However, the vast majority
of people can open the database just fine.

Is there some setting I'm missing somewhere? Can anyone
tell me why this error is happening? Thank you.

-LB

 

[Joan Wild]

Ensure all users have full permissions on the network folder.

 

[Rick B]

It could also be that they do not have delet permission.


Rick B

I'm betting that those users do not have "write" permissions to the lan
folder in which the file lives. this is preventing them from updating the
ldb file.

I would, however, expect it to open the file as read-only for those users,
so I could be wrong in my assumption.

Rick B



Hello,

I have a user who has an MDE database on the network
accessed by many other users. When a handful of users
tries to open the database they get an error that
states "Could not lock file". However, the vast majority
of people can open the database just fine.

Is there some setting I'm missing somewhere? Can anyone
tell me why this error is happening? Thank you.

-LB

 

[Linda B]

The strange thing was that the folder was read-only for
everyone, but only half a dozen people were having trouble
accessing the database. But I gave it a shot, opened up
the permissions, and everyone can get in now.

As far as I'm concerned, all's well that ends well, so I'm
asking no questions. Thanks for your help!


LB

 

[Bharat]

Cause:
======
Insufficient Share permissions for the users accessing
the database.

Resolution:
==========

1. Grant at least Change permissions for the Share
permissions to the users accessing the database.

2. If you are using both Share and user-level
permissions, the most restrictive
permissions will be provided to the user. Make sure both
sets of permissions are adequate for accessing the
database.


3. Users need to have Write permissions to the file.
Right-click on the file -> Properties -> Security -select
Write


Related Knowledgebase Articles:

===========================

ACC2000: Introduction to .ldb Files

http://support.microsoft.com/support/kb/articles/q208/7/78
..asp

 

[Joan Wild]

Users need create permissions on the folder in order to create the
associated ldb file. Without that permission, the ldb won't get created and
the mdb gets opened exclusively.