Error "Could Not Lock File"

[Guest]

I have several .mdb data files containing only tables that are shared by 4 or
5 users. Each user has an application file on their computer and each
application is linked to the tables in the data.mdb file on the server.

I am using Windows XP and MsAccess 2000
We just changed from Windows NT4.0 to Server 2003
I moved my data files to the new server and set sharing to Full Control for
the folders. I also checked to Inherit Parent Permissions as I have always
done in the past. I have never set up security permissions before.

Now only one user at a time can access and edit the data files.

I have Tools/Options set for the default “Sharedâ€, and “No Locksâ€

When I try to open the linked application on a second computer I receive the
error “Could not lock file.â€

I set up a test .mdb file with only one table and no matter what I do, only
one user at a time can edit the table. I have also played with the security
tab giving each user full control. Still each computer can access and edit
the file but only one at a time.

Can any one help?

Thanks in Advance

Paul M

 

['69 Camaro]

Hi, Paul.

When I try to open the linked application on a second computer I receive
the
error "Could not lock file."

This is sufficient proof that you do not have modify permissions to add a
user's entry to the locking database file (*.LDB). Therefore, you do not
have Full Control Windows security permissions on that directory.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.