Compact and Repair Database

You can do yourself to prevent you from the corruption of access Database (.mdb) or to ensure a optimal performance, you should compact and repair your Microsoft Access files on a regular basis. If you're using or working with a large access Database and need to compact and repair the database whenever u are exiting from the program. Just follow the steps below:

1. If you are compacting a shared Microsoft Access database that is located on a server or shared folder, make sure that no one else has it open.
2. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.

o Compact and Repair an Access Database that is not open

1. Close the current Microsoft Access file. If you are compacting a shared Access database that is located on a server or shared folder, make sure no one else has it open.
2. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
3. In the Database to Compact From dialog box, specify the Access file you want to compact, and then click Compact.
4. In the Compact Database Into dialog box, specify a name, drive, and folder for the compacted Access file.
5. Click Save.

To Compact and Repair an Access file automatically every time you close it

Compacting does not occur if you close a shared Access database while another user has it open.

1. Open the Access database or Access project that you want Microsoft Access to compact automatically.

2. On the Tools menu, click Options.
 
3. Click the General tab.

4. Select the Compact on Close check box.

Note: You can stop the compact and repair process by pressing CTRL+BREAK or ESC.