“Access Has Detected That This Database Is in an Inconsistent State”
The full message reads: “Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database.” It means the file was damaged, usually because a write was interrupted. Access will try to repair it automatically, but that repair can quietly delete forms, reports, modules, or records it can’t read.
Common causes
- Access closed unexpectedly (crash, forced shutdown, power loss) while the database was open
- A Wi-Fi or VPN connection dropped while someone was editing data
- Multiple users sharing one unsplit database file on a network drive
How to fix it
- Cancel and make a copy first, if you can. Let Access run its recovery on the copy, not the original.
- Let the recovery finish, then open the copy and check that your tables, forms, reports, and modules are all still there.
- Look for missing objects. If Access hit problems during repair, it may log them in a hidden system table called MSysCompactErrors (turn on Show System Objects in the Navigation Options to see it). If anything is missing, import it from your most recent backup.
- Run Compact and Repair again once the database opens.
- Check recent records in key tables. Records being edited at the time of the crash are the most likely to be lost or damaged.
Stop it from happening again
This error almost always comes back if the cause isn’t fixed. Split the database so each user has their own front-end, keep the back-end on a wired network, and don’t run a shared back-end over a VPN.
Seeing this more than once?
Repeated corruption is a warning sign that the database is at risk. Book a free diagnostic and we’ll find the root cause, or see our Access Database Repair service.