Your At Your Service Microsoft Access database can usually be repaired in the rare case that it ever becomes corrupted (e.g. after a power failure or system or network crash). The database repair process also analyzes the database for data integrity in order to resolve potential data problems, and compacts the physical size of the database (see Optimizing the Database for Speed).
If database corruption is detected when opening a database (see Opening an Existing Access Database) then an automatic attempt will be made to repair and compact the database before opening it.
NOTE Before repairing and compacting the database, you must ensure that all other users are out of the database. This includes temporarily closing the At Your Service – Internet Utility (see Exiting the Internet Utility).
The database repair and compact process can also be started
manually by the system administrator or by any Repair Mobile edition user. To
repair and compact the open database file, or the most recently opened database
file if one is not presently open, first close all windows within the main
program shell and then select File Repair and Compact Database from the
main menu. Only the program administrator (see User
Security) may repair and compact a database from within the main At Your
Service – Repair Centre program. A prompt will verify the request to repair
and compact the database before proceeding, and a completion message will appear
at the end of the process indicating the percentage by which the database was
physically compacted.
An Access database can also be repaired and compacted using the At Your Service - Database Repair Utility (see Repairing a Database).
In a worst-case scenario where an Access database cannot be automatically repaired by one of the above processes, the database can be sent to At Your Service Software, Inc. so that a support technician can attempt to manually recover the database (see Sending a Database File for Manual Repair), or a database backup can be restored (see Restoring a Database Backup, and Restoring a Backup Database).
(See also Repairing a MySQL Database, and Repairing a Microsoft SQL Server Database.)
More: