troubleshooting Question

How do I fix Microsoft Access 'Cannot Lock File' error

Avatar of WoodstockIT
WoodstockIT asked on
Microsoft AccessServer HardwareActive Directory
6 Comments1 Solution12046 ViewsLast Modified:
I have an existing Microsoft Access 2000 database that is split with front end/back end. It is on a network file server and is accessed via network shares. There is a current group of users who have been successfully accessing it simultaneously; some using Windows 2000 Pro/Office 2000 and some using Windows XP Pro/Office 2003. I am now adding 2 new users, 1 2000 Pro/Offc 2000 + 1 XP Pro/Offc 2003, who each get the 'cannot lock file' message if anyone of the original group is using the database, otherwise they can access the file. Further if either of the 2 new users log on first, any of the original users can use the database but only as read-only. Both original and new users all have the same NTFS permissions to the database and folders on the network.  Any help to solve this will be most appreciated.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros