Access Datasbase Issues and Corruption

Be sure to make a Backup before attempting any type of recover. This includes running compact and repair.

If you do suspect you have any database issues the first thing you should do is exit the database and make a backup.

Hits: 1733
Corrupt Microsoft Access MDBs FAQ
Tony Toews has an excellent web page on database corruption.
Hits: 2070
Recovering from corruption
This article may help if your database is already corrupt
Hits: 1788
Preventing corruption
Since the Access database is a single mdb file, you can lose everything if it becomes corrupt. This is a rare occurrence if the database is running on reliable local area network (or single computer) and database objects are not being modified.
Hits: 2373
Jet compact utility is available in download center
The Jet compact utility, JETCOMP.exe, is a stand-alone utility that compacts databases created with Microsoft Jet database engine 3.x and 4.x. This utility may be run in conjunction with Microsoft Jet database engine 3.x and 4.x for recovering corrup
Hits: 4419
Microsoft Jet Utilities
The Jetutils.exe file contains the "Understanding Microsoft Jet Locking" white paper, the LDBView utility, the DBLock utility, and the Msldbusr.dll. The white paper introduces you to the Microsoft Jet Database Engine versions 2.x and 3.x locking techniques so that you can apply the information to coding and debugging techniques when you develop multi-user applications.
Hits: 1403
Fix Corrupt Access Database v4.5
by Jerry Whittle, Microsoft MVP - Access Here is a list of tips and tricks in a checklist format to help those with a corrupt database.