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:
or My Site:

LEARN MORE:
File In Use:

PREREQUISITES:
Compact & Repair:

LINKS:
Backup Access:
File Sharing Services:
Troubleshooter:

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: (Mike Wolfe)
Access Forever: (Karl Donaubauer, et al.)
Official Microsoft Access Blog: (Access Team)

ACCESS REPAIR SERVICES:
Everything Access: (Wayne Phillips)
Access Experts: (Juan Soto, et al.)
Winning Solutions, Inc. (Bob Estabrook)

RECOMMENDED COURSES:
FREE Access Beginner Level 1:

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates:
Blank Template:
Contact Management:
Order Entry & Invoicing:
More Access Templates:

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1:
How to Use Access in 30 Minutes:
$1 Access Level 2:
Donate to my Tip Jar:
Get on my Mailing List:
Contact Me:
TechHelp:
Consulting Help:
Twitter:

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.

[ad_2]

source