When Your Access Database Is Corrupted

When your Access database is corrupted, it can feel like a nightmare for your business. But don’t panic! There’s a clear sequence to follow that can help you recover your data. Start by stopping all activity on the database to prevent further damage. Then, rule out simpler problems before making a copy of the file. From there, you can run the built-in Compact and Repair tool, decompile if necessary, and even import everything into a new database. If all else fails, consider reaching out to a specialist. Discover the steps to safeguard your data and restore your database effectively!

Table of Contents

Have an Access problem right now?

Short answer: Stop everyone from using the database, make a copy of the file, then work through Compact and Repair, decompiling, and importing into a new database, in that order. Most Access corruption is recoverable if you don’t make it worse in the first few minutes.

Finding out your Access database won’t open, or opens with errors and missing data, is one of the most stressful moments in running a business on Access. The good news: there’s a clear sequence to follow before you conclude anything is lost.

Signs Your Access Database Is Corrupted

Corruption usually shows up as one of these:

Step 1: Stop Writing to the Database

The moment you suspect corruption, stop all activity. If several people use the database, have everyone close it now. Every save risks overwriting the data you’re trying to recover. Treat it like a failing hard drive: the less you touch it, the better your odds.

Step 2: Rule Out Simpler Problems

Before assuming corruption, check the easy causes:

  • Can you reach the file? Confirm the network drive or folder is connected.
  • Can anyone else open it? Try a different computer.
  • Is it near 2 GB? Check the file size in File Explorer. Access stops working at 2 GB (see the 2 GB limit).
  • Is there a leftover lock file? When Access opens a database, it creates a lock file with the same name and a .laccdb extension (.ldb for older .mdb files). If Access crashed, that file can stay behind and block access. If you’re sure nobody is in the database, close Access everywhere and delete it. This often fixes “file already in use” errors that look like corruption.

A dropped connection can also cause “Your network access was interrupted”, which isn’t always corruption.

Step 3: Make a Copy Before You Do Anything Else

Before running any repair, copy the .accdb or .mdb file to your own computer, not just another folder on the same network drive. Repairs can occasionally make things worse, and you want an untouched copy to fall back on or hand to a specialist. Do all of the following steps on the copy.

Step 4: Run Compact and Repair

Access has a built-in Compact and Repair tool for exactly this. Nobody else can have the file open while it runs.

  • If the database opens: go to File > Info > Compact & Repair Database.
  • If it won’t open: start Access, create a blank desktop database, then go to Database Tools > Compact and Repair Database and select the damaged copy.
  • If Access offers to repair it when you open the file, say yes.

The tool rebuilds the file’s internal structure, fixes index problems and reclaims wasted space. For minor corruption, this is often all you need.

Step 5: Decompile If the Problem Is in the VBA Code

If the database opens but crashes on startup, freezes on certain forms, or throws VBA errors that weren’t there before, the damage may be in the compiled code rather than the data. Open Access with the /decompile switch from a command prompt or shortcut:

"C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" "C:\path\to\your.accdb" /decompile

If you use 32-bit Office, the program is usually under C:\Program Files (x86) instead. After it opens, go into the VBA editor and choose Debug > Compile, then run Compact and Repair again. If errors like “Can’t find project or library” appear, that’s a missing reference, not corruption.

Step 6: Import Everything Into a New Database

If Compact and Repair doesn’t fix it, create a new blank database and import the objects from the damaged copy. This often works because importing reads each object’s definition rather than the damaged file structure.

In the new database, go to External Data > New Data Source > From Database > Access, select the damaged copy, and choose import (not link). Bring in tables first, then queries, then forms, reports and modules. If one object fails, skip it and keep going. You may lose one damaged form but recover everything else.

Step 7: Restore From a Backup

If the repair steps don’t work, this is when your backup routine pays off. A nightly backup of the back-end file limits your worst-case loss to one day. Restore the most recent clean copy, then re-enter anything added since from paper records, emails or other sources.

If you don’t have a backup, that’s a problem to fix right after this incident, not during it.

Step 8: Try a Third-Party Recovery Tool

When Access’s own tools fail, commercial recovery tools can sometimes pull data out of files Access can no longer read. Options include Stellar Repair for Access, DataNumen Access Repair and SysTools Access Recovery. Most offer a free preview that shows what they can recover before you pay. Always run them on a copy.

Step 9: Call an Access Repair Specialist

If you’ve reached this point and the data matters to your business, stop experimenting. Every failed attempt can reduce what’s recoverable. An experienced Access developer can often recover tables, rebuild damaged forms and VBA, and get you running again, usually faster than a generic data recovery service.

Database down right now? Our Access database repair service handles emergency recoveries. Book a free diagnostic or call 623-267-5720.

Step 10: Prevent the Next Corruption

Access corruption most often comes from a dropped connection mid-save, improper shutdowns, unreliable network paths, or databases that are never compacted. To prevent it:

  • Split the database into a front end for each user and a shared back end.
  • Keep the back end on a reliable file server. Never store it in OneDrive, Dropbox or a synced SharePoint folder, which commonly corrupt Access files.
  • Use wired connections. Wi-Fi and VPN drops are a leading cause of corruption.
  • Back up nightly, automatically, and test a restore now and then.
  • Compact regularly: monthly at minimum, weekly for busy databases.

Our Access maintenance and support plans handle all of this for you.

If your database keeps corrupting despite all this, it has outgrown what Access was built for. Moving the tables to SQL Server or the whole app to Power Apps on Dataverse removes the single fragile file altogether. See How to Know When It’s Time to Migrate Off Microsoft Access.

Frequently Asked Questions

Why does my Access database keep getting corrupted?

The most common causes are network drops while saving, storing the file in OneDrive or another sync folder, users on Wi-Fi or VPN, too many simultaneous users, and a database that isn’t split or compacted regularly.

Can a corrupted Access database be recovered?

Usually, yes. Most corruption is fixed with Compact and Repair, decompiling, or importing into a new database. Severe cases may need a backup, a recovery tool or a specialist.

What if Compact and Repair doesn’t work?

Try decompiling the database, then importing all objects into a new blank database. If that fails, restore from backup or contact an Access repair specialist before trying anything else on the file.

How do I stop users from corrupting the database?

Split the database so each user has their own front end, keep the back end on a wired, reliable file server, and schedule nightly backups and regular compacting.


Anthony Passeri, MBA, is the founder of Access Evolved and a certified Microsoft Access Expert with 21+ years of Access and relational database experience. He helps businesses keep critical Access databases running and modernize them to Power Platform or SQL Server. More about Anthony

Talk to an Access Expert

Not sure what this means for your database? Book a free diagnostic call. No sales pitch, just a straight conversation about what makes sense for your situation.

Book a Free Diagnostic

Phone: 623-267-5720

Email: info@accessevolved.com

Access Evolved | 19580 W Indian School Rd, Ste 105 #815, Buckeye, AZ 85396

Sources

Related Reading

Access Evolved Microsoft Access Consultant

Converting an Old Microsoft Access Database to a Modern Platform

Converting a legacy Microsoft Access database is a pivotal decision for small and mid-sized organizations. A successful migration can eliminate years of technical debt, enabling mobile access, real-time collaboration, and
May 6, 2026
Access Evolved Microsoft Access Consultant

Designing Access Tables and Relationships: Best Practices

Designing tables and relationships is crucial for a successful Access database. A well-structured design ensures that forms, queries, and reports remain accurate as your data grows, while poor design leads
October 11, 2026
Access Evolved Microsoft Access Consultant

What is the best replacement for Microsoft Access?

Are you considering a replacement for Microsoft Access? For businesses using Microsoft 365, Power Apps paired with Dataverse or SharePoint is often the best choice, allowing you to modernize your
October 29, 2026
Access Evolved Microsoft Access Consultant

How to Know When It’s Time to Migrate Off Microsoft Access

Is your Microsoft Access database becoming a liability? For over 30 years, Access has powered small and mid-sized businesses, but as time goes on, critical issues can arise. From reliance
April 9, 2026
what can power apps do for your business

What Is Power Apps and What Can It Do for My Business?

Power Apps is a game-changing Microsoft tool that empowers businesses to create custom applications without the need for a software development team. Imagine transforming your outdated spreadsheets and paper forms
September 2, 2026
ms access frequently asked questions

FAQs About MS Access

Are you considering Microsoft Access for your data management needs? This powerful relational database program is perfect for individuals and small teams looking to store, search, and report on structured
April 22, 2026

Need Help With This?

Scroll to Top