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

Hi, Paul.

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.

cannot clear password with 2003 or 2007
Why can't I delete a user?
Permission should be permission, right?!?!
folder security nightmare to allow .ldb file deletion
Permissions and Object Owners
Two Simple Questions on Security
MS Access 2003 w/SP3 should not require Full Control permissions
Open database while holding down shift key
Access gone wild
Adding new user's password