neilwebber
Registered User.
- Local time
- Today, 04:17
- Joined
- Aug 19, 2002
- Messages
- 35
I had a sudden problem with a corrupt front-end database.
On opening, or any other action for that matter, I got the following message:
"x.mdb has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to the Database Utilities and click Compact and Repair Databsae. If you are currently trying to repair this corruption then you will need to recreate this file or restore it from a previous backup."
I had access to the database window but modules and queries wouldn't open. Compact and repair had no effect, nothing would export or import into a new database and the JetComp utility also had no effect.
I finally found a simple solution courtesy of a guy called Steve Watmough on database.ittoolbox.com
This worked for me
On opening, or any other action for that matter, I got the following message:
"x.mdb has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to the Database Utilities and click Compact and Repair Databsae. If you are currently trying to repair this corruption then you will need to recreate this file or restore it from a previous backup."
I had access to the database window but modules and queries wouldn't open. Compact and repair had no effect, nothing would export or import into a new database and the JetComp utility also had no effect.
I finally found a simple solution courtesy of a guy called Steve Watmough on database.ittoolbox.com
Code:
'Run the following code from a blank database:
Dim appAccess As New Access.Application
appAccess.CompactRepair "PathtoCorruptDatabase", "ANewDatabase"
This worked for me