troubleshooting Question

Database Engine could not lock table.....error message

Avatar of hominus7
hominus7 asked on
Microsoft Access
9 Comments4 Solutions841 ViewsLast Modified:
I have a live db running on a VPN network (FE/BE both centrally located on a main server , users 'view' their own personal front end through the VPN tunnel rather than having it on their client pcs) ) and have recently provided a new update to the existing Front End. Until this time , some users were problem free but some persisted in getting the above message. Now the new update is in place , they all get it, and this when no one is using the db and a single user logs in and tries to use the system. I guessed initially it must be a design fault ( ie mine ) but then why does it work for some and not for others?. It also works no problem on my network at home ( Windows XP, Access 2003) (. The user runs Access 2000.My db was developed in 2003 ( but saved in the default 2000 file format ). My online searches have started to uncover references to installation of SP5 and BDE. Is this the right direction?I have to go in tomorrow to sort it out so Im giving it urgent points value
Any help most appreciated.
Thanks in advance.

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

Join our community to see this answer!
Unlock 4 Answers and 9 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 4 Answers and 9 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