How to Fix "File Already in Use" and "Already Opened" Errors When Compacting in Microsoft Access

In this Microsoft Access tutorial, we're going to learn how to deal with experiencing the "File already in use" error message when you try compacting your database. You may also get the error message saying, "You attempted to open a database that's already opened by another user. Try again when the database is available." We'll talk about both of these issues today. Kieran from Miami, Florida (a Platinum Member) asks: I try to compact my database at least once a week, like you told me in your compacting video. But it seems most of the time when I do, I get an error message saying that the database is already in use. I do have a few other people on my network, but I always make sure that everyone's logged out. In fact, no one else is here in the office and all the computers are off, but I still get the error message. What gives? BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: File In Use: https://599cd.com/FileInUse PREREQUISITES: Compact & Repair: https://599cd.com/Compact LINKS: Backup Access: https://599cd.com/Backup File Sharing Services: https://599cd.com/FileSharing Troubleshooter: https://599cd.com/Trouble CHECKLIST: Make sure everyone is out of the database (including you) Delete the LACCDB file Make sure no MSACCESS.EXE tasks are running Open with SHIFT key bypass Try compacting a copy of the database file Don't use a shortcut (go in thru Access - File - your database) Restart Windows Office Update (check bug reports) Create a new blank database, import objects Import objects one at a time Turn off File Sharing Services (Google Sync, Dropbox, etc.) Check my Troubleshooter BUG ALERTS: No Longer Set: https://nolongerset.com (Mike Wolfe) Access Forever: https://www.accessforever.org (Karl Donaubauer, et al.) Official Microsoft Access Blog: https://599cd.com/AccessBlog (Access Team) ACCESS REPAIR SERVICES: Everything Access: https://www.everythingaccess.com (Wayne Phillips) Access Experts: https://accessexperts.com (Juan Soto, et al.) Winning Solutions, Inc. https://microsoftaccessexpert.com (Bob Estabrook) RECOMMENDED COURSES: FREE Access Beginner Level 1: https://599cd.com/Free1 FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree Blank Template: https://599cd.com/Blank Contact Management: https://599cd.com/Contacts Order Entry & Invoicing: https://599cd.com/Invoicing More Access Templates: https://599cd.com/AccessTemplates ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 How to Use Access in 30 Minutes: https://599cd.com/30Minutes $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS: access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Can't compact database, file already in use, could not use, accdb, you attempted to open a database that is already opened by user x on machine y, try again when the database is available, fix corrupted microsoft access database, How to Recover and Repair Corrupted Access Database Files, ACCDB Recovery Tool, access database repair services QUESTIONS: Please feel free to post your questions or comments below. Thanks.