could not update; currently locked

We have 2 users of an access 2010 application who get an error ''could not update;  currently locked'. I have tracked down the row in the table that these forms are accessing and can see no issues at all, e.g. signs of corruption. Is there anything else that can be done. There are a few forms that show/update date in this particular row, unsure really what may cause this, but as its affecting multiple users each with their own FE the common denominator being that row, what can be done.
If I connect to the backend of the system and try and manually edit a single column in the record it gives the same error.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<If I connect to the backend of the system and try and manually edit a single column in the record it gives the same error.>>

 With everyone out of the DB, delete the .LDB file in the directory where the BE DB resides.

 If you cannot delete it, then a lock is being held, probably by someone that exited Access with Ctrl/Alt/Del.   In that case, the simplest thing to do is reboot the server.

 If that's not easily doable, there are other means to clear the lock.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pma111Author Commented:
Yes we don't have admin rights over the server, and its a shared file server used by a few hundred staff. Any other techniques.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Yes we don't have admin rights over the server,>>

Don't think you'll be able to clear the lock without admin rights.  You need access to computer management:

 and close the file.

 This only works though if the user is a network user (sounds like it is).   But if this is a terminal services server, then the access is local.  For that, you need to use Process Monitor to find the handle for the file and close it manually.

Get a highly available system for cyber protection

The Acronis SDI Appliance is a new plug-n-play solution with pre-configured Acronis Software-Defined Infrastructure software that gives service providers and enterprises ready access to a fault-tolerant system, which combines universal storage and high-performance virtualization.

pma111Author Commented:
I'll speak to the server team then. But your suspicion is the cause of the error is a lock I presume.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
With everyone out of the app, the .LDB file should disappear.

 If it's still there and you cannot delete it, then a lock is still being held.

pma111Author Commented:
Trying to track it down now. It would be a network user. It wont be an RDP session, we do have a citrix access gateway but it logs them onto a citrix server. Nobody bar IT access the file server via RDP.
pma111Author Commented:
Turned out someone connected to the system via our VPN which crashed and for whatever reason access did not release the lock. Once they re-established a connection again to the file again via VPN it all worked again and the record could be amended.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
That will do it.   With a JET/ACE backend, all the db processing is carried out on the client side.  The server only acts as a file sharing device.  So any abnormal disconnect is a problem.

 Any remote users you have should be setup with RDP.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.