Troubleshooting
Access Database Stopped Working? What to Do First (and What Not to Do)
Short answer: stop, make a copy of the database files before anyone touches anything, and then work through the causes below. Most "broken" Access databases can be fixed, and it's almost never because Microsoft switched Access off.
If an Access database your business depends on just stopped opening, started throwing errors, or suddenly has buttons that do nothing, it's easy to assume the worst, especially with all the talk about Access being "dead." The reality is more reassuring. Unsupported versions of Access don't shut down, and the problems that stop a database in its tracks usually have a specific, findable cause. The biggest risk at this point is making it worse while trying to fix it.
Do This First: Protect What You Have
- Get everyone out of the database. Every open copy can keep writing to a damaged file.
- Copy the files somewhere safe. Copy the .accdb (or .mdb) file, and if your database is split, copy both the front end and the back end. Work only on the copies from here on.
- Write down the exact error message and what changed recently: a new computer, an Office or Windows update, a moved network drive, a new user.
- Find your most recent good backup before you need it, and check that it actually opens.
Only then start troubleshooting. Every fix below is safer on a copy.
Match Your Symptom to the Likely Cause
| What you're seeing | Most likely cause | Where to start |
|---|---|---|
| "Unrecognized database format" or "database is in an inconsistent state" | File corruption, usually from a dropped network connection, Wi-Fi, or many users in one shared file | Run Compact and Repair on a copy. If that fails, restore from backup. |
| A red "Security Risk" bar saying macros are blocked, or buttons that suddenly do nothing | Office blocks VBA macros in files that came from the internet or email | If the file is from a trusted source, open its Properties and select Unblock, or put it in a Trusted Location. |
| "The code in this project must be updated for use on 64-bit systems" | A new computer with 64-bit Office running code written for 32-bit | Update the VBA Declare statements with PtrSafe, or install 32-bit Office on that machine for now. |
"Can't find project or library," or errors on simple functions like Date() or Left() | A missing VBA reference | In the VBA editor, go to Tools > References and look for anything marked MISSING. |
| "ODBC call failed," "could not find file," or linked tables showing errors | A server, network drive letter, folder, or SQL driver changed | Open the Linked Table Manager and relink to the correct location. |
| "The database is already in use" or it opens read-only | A leftover lock file (.laccdb) or missing folder permissions | Once everyone is out, delete the leftover .laccdb file. Users need permission to create and delete files in that folder. |
| Broke the same day an Office or Windows update installed | An update changed or broke a behavior | Check Microsoft's list of known Access issues and fixes, then update Office again, since fixes often arrive quickly. |
| Slow, freezing, or timing out | File approaching the 2 GB limit, an unsplit database, too many users, or running over VPN or Wi-Fi | Check the file size, split the database, and keep the back end on a wired local network. |
Tip: If more than one of these showed up at once, look for the single thing that changed. A new computer, a new Office install, or a moved network share usually explains several errors at the same time.
What Not to Do
- Don't run Compact and Repair on your only copy. It usually helps, but when it fails on badly damaged files, you want the original untouched.
- Don't let everyone keep working in a database that's corrupting. Each session can spread the damage and make recovery harder.
- Don't store a shared database in OneDrive, Dropbox, Google Drive, or a synced SharePoint folder. File sync and Access's record locking don't mix, and it's a common cause of repeated corruption.
- Don't buy recovery software before you've copied the files and tried a backup restore.
- Don't "fix" it by rolling everyone back to an old, unsupported version of Office. That trades today's problem for a security problem.
How to Keep It From Happening Again
- Split the database into a front end (forms, reports, code) on each computer and a back end (data) on the server.
- Back up automatically and test restores. A backup you've never opened isn't a backup.
- Keep everyone on the same supported version of Access. Mixed versions cause odd errors. See which versions are still supported.
- Document how it works, so a problem isn't a crisis just because one person is out.
- Watch for outgrowing it. Repeated corruption, remote users, and a file creeping toward 2 GB are signs it's time to plan a move. Use the 15-point checklist to find out.
Common Questions
Will my Access database stop working when Microsoft ends support?
No. Unsupported versions of Access keep opening and running. Databases stop working because of corruption, updates, blocked macros, 64-bit Office, or changed network paths, not because support ended.
Can a corrupted Access database be recovered?
Often, yes. Compact and Repair fixes many cases, and a recent backup covers most of the rest. Always work on a copy. Badly damaged files may need specialist recovery of the tables.
Why did my Access database stop working after an update?
Office and Windows updates occasionally change behavior that older databases depend on. Microsoft publishes known Access issues and fixes, and installing the latest Office update often resolves them.
Can I keep a shared Access database on OneDrive or SharePoint?
Not safely. File-sync services like OneDrive, Dropbox, and synced SharePoint folders conflict with how Access locks records and are a common cause of corruption. Keep the back end on a local network share or move the data to SQL Server or Dataverse.
Database down and the business is waiting?
Talk to an Access specialist about recovering it, stabilizing it, and keeping it from happening again. No obligation.
Get Help With a Broken Access Database →Help is provided by Access Evolved, a Microsoft Access and Power Platform consultancy.