Listed below are common error messages that generally indicate database corruption. To assist you with database corruptions, we have teamed with the developers of the best online Access repair service to produce a recovery system that we believe is the best service available. Garry Robinson - Editor of vb123.com
(Please note that this is not an extensive list - just some examples of common error messages encountered by users that often indicate that the database has become corrupted)
Your database contains a table called msysCompactErrors
In the folder where your database(s) lives, you find databases called db1.mdb, db2.mdb, db3.mdb, db4.mdb, db2.mdb, db5mdb, db6.mdb, db7.mdb, db8.mdb db9.mdb. This is a sign the one database in the folder is not compacting properly.
In the folder where your database(s) lives, you find databases called _backup. This is a sign that the backup database is not compacting properly. This database should be cleaned up as is it is a security risk.
Unrecognized Database Format (When your database was operating correctly under your current version of Access previously) Error number 3343
This database is in an unrecognized format. The database may have been created with a later version of Microsoft Access than the one you are using. Upgrade your version of Microsoft Access to the current one, then open this database
Enter password (when one hasn't been applied!)
The Microsoft Jet Database Engine cannot open the file Error number 3051
The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time Error number 3191
AOIndex is not an index in this table
This database is in an unexpected state; Microsoft Access can't open it.. The database has been converted from a prior version of Microsoft Access by using the DOA compact database method instead of the convert database command on the tools menu. This has left the database in an unconverted state.
This database is in an unexpected state; Microsoft Access can't open it. This database has been converted from a prior version of Microsoft Access by using the DAO CompactDatabase method instead of the Convert Database command on the Tools menu (Database Utilities submenu). This has left the database in a partially converted state. If you have a copy of the database in its original format, use the Convert Database command on the Tools menu (Database Utilities submenu) to convert it. IF the original database is no longer available, create a new database and import your tables and queries to preserve your data. Your other database objects can't be recovered.
You do not have the necessary permissions to open this object. Please contact your system administrator.
* isn't an Index in this table. Look in the index collection of the TableDef object to determine the valid index names
Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.
Unexpected error 35012 (opening file)
This object needs a newer version of the Microsoft Jet database module
The database is in an unexpected state ...
Operation failed - too many indexes - reduce the number and try again
Access crashes (Invalid Page Fault/GPF) when opening the mdb
The instruction at "0x????????" referenced memory at "0x????????". The memory could not be 'written'
The Visual Basic for Applications Project in this database Is Corrupt
The Microsoft Jet Database Engine could not find object Msys*/databases. Make sure the object exists and that you spell its name correctly and the path name correctly
Could not find field 'xxx'
You get a message saying "Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time"