CODEWITHSUNDEEP
ms-accesscompact-database
MGilbert
MGilbert

Reputation: 41

MS Access 365 error - compact and repair error

I am suddenly receiving the below error message when attempting to compact and repair my access databases. Clicking ok on the error message results in original .accdb file being deleted and an .mdb being saved out. When entering the database I'm not in read only so I'm confused on what is happening.

Microsoft Access can't delete accdb file path after compacting it. The compacted database has been named new mdb file path

Upvotes: 0

Views: 2912

Answers (1)

iDevlop
iDevlop

Reputation: 25252

When I have a database corruption that is not easily solved, I generally create a new, blank database, then import everything from the faulty db.
It's reasonably fast, and you can actually see and take note of which object fails to import. You can then import the problematic object(s) from your last backup.
Also: do all that stuff on a LOCAL drive, not a network drive. Network drives often are the culprit.

Upvotes: 0

Related Questions