We help IT Professionals succeed at work.

could not update; currently locked

69 Views
Last Modified: 2019-03-07
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.
Comment
Watch Question

President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

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 (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
<<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:

Region-Capture.jpg
 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.

Jim.

Author

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 (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
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.

Jim.

Author

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.

Author

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 (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
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.

Jim.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.