Section 2: Getting Started > Working with Microsoft Access Databases

Repairing and Compacting an Access Database

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.)


Archiving an Access Database