Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Access lock file persists
Jennifer Neighbors 
     
2 years ago
The lock file (.laccdb) persists when I close an Access instance. My computer thinks Access is still active, and if I open the file again, it says someone else is using it, so I cannot save changes. Has anyone else experienced this? Is this a bug, or am I doing something wrong? This is very annoying because I have to restart my computer to kill the lock file.
Richard Rost  @Reply  
          
2 years ago
Are you running your database out of a shared folder, perhaps with Google Drive, Dropbox, OneDrive, or one of those services? Because if that's the case, the lock file might be in the process of being backed up by Google Drive, and that's why Access can't delete it when it closes. I know this because I run some of my simple databases out of my Google Drive folder and this happens to me occasionally.
Jennifer Neighbors OP  @Reply  
     
2 years ago
Richard - I moved my file out of OneDrive to my hard drive. I then opened and closed it. The lock file persisted. I'm eager to get this fixed!
John Campbell  @Reply  
     
2 years ago
Yes, this has happened.  Instead of rebooting, open task manager, scroll down the 2nd list of processes and look for "ms Access" session, right click and kill the process.

This is a pain
Jennifer Neighbors OP  @Reply  
     
2 years ago
John, ending the process in the Task Manager doesn't work for me. And, this issue happens each and every time I open and close my database. So it's crippling me.
Kevin Robertson  @Reply  
          
2 years ago
I just right click on the Application Icon to close an unresponsive program.

End Task

Less of a pain (and quicker than opening the Task Manager).
Jennifer Neighbors OP  @Reply  
     
2 years ago
John - I now see what you mean by the second list of processes. Yes, that DOES work. Thanks for the tip!
Jennifer Neighbors OP  @Reply  
     
2 years ago
Thanks to all who have helped me with this. However, nothing has helped me prevent this from happening each time I open my Access database. Could it be corrupted? Perhaps I should create a new, blank database and import all my objects into it. Just wondering.
Richard Rost  @Reply  
          
2 years ago
Yeah, killing the non-responsive process is not going to delete the lock file. It'll shut down Access, but it won't delete the LACCDB file. I remember reading something about this recently...

According to GPT:

It seems there's a known issue with Microsoft Access where the lock file (.laccdb) is not being deleted properly when the database is closed. This problem is often due to bugs introduced in certain Access updates. Specifically, one bug was reported in build 14827.20158, where Access remains running in the background even after closing the window, causing the lock file to stay active. This can prevent other users from accessing the database or lead to errors like "Cannot open any more databases" or "Already in use" messages.

In some cases, manually closing the Access process in the Task Manager or rebooting the system can resolve the issue, but a permanent solution often requires rolling back to a previous version of Access that does not have this bug. Additionally, ensuring that all VBA objects are properly closed and performing regular compact and repair operations can help alleviate this issue.

Microsoft has since fixed this in later updates, so make sure you are on the most recent build. If the issue persists, reverting to an older version or manually deleting the lock file when it's safe to do so might help in the meantime.


Looks like this issue was from a couple years ago though. Have you done an Office Update lately?
Jennifer Neighbors OP  @Reply  
     
2 years ago
Richard, My O365 gets updated automatically, and I'm current with the latest. However, I may "roll back" if this is causing the problem. Thank you for the advice.
Jennifer Neighbors OP  @Reply  
     
2 years ago
For your information, I rolled back to the prior release and stopped automatic O365 version updates. This seems to have resolved the problem for now.
Richard Rost  @Reply  
          
2 years ago
OK good. Yeah, I had to roll back a little while ago myself. The Access Team needs to figure this $#@! out.
Donald Lader  @Reply  
      
2 years ago
I had this issue along with multiple access processes starting on their own. I just got very quick with task manager. However, about two or three weeks ago this all stopped and access works just full me now. I am thinking perhaps while Richard was out exploring new worlds this summer he may have brought something worse than a tribble back and it jumped into his code. Maybe Scotty installed nanobots on his server to clean them out.
Peter Macwilliam  @Reply  
     
2 years ago
WE have had a similar problem, in that Access would not remove itself from active tasks, seems to be a bug in the Office 365 version build 2408.
Roll back your office version and see if it solves the issue.
Alex Hedley  @Reply  
           
2 years ago
Jeffrey Kraft  @Reply  
      
2 years ago
Peter mentioned it already.  I whinned about it last week.  For me it was a recent update to Office. I rolled back to an earlier release... and problem be gone.
Gary Becker  @Reply  
     
2 years ago
I had this problem, too, this morning, and Alex steered me to this link. After rolling back to Version 2407 Build 17830.20166, it looks like my database is working again.
Dennis Bowman  @Reply  
    
2 years ago
If you have one drive saving it to you c: drive attaches is to one drive.
Map a drive, save the file to that drive

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/27/2026 8:07:46 PM. PLT: 0s