Compact an Access database or Access project that is not open

Compact an Access database or Access project that is not open

  1. Close the current Microsoft Access database or Microsoft Access project. If you are compacting a multiuser (shared) 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 database or Access project 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 database or Access project.

  5. Click Save.

    If you use the same name, drive, and folder, and the Access database or Access project is compacted successfully, Microsoft Access replaces the original file with the compacted version.

Note   You can stop the compacting process by pressing CTRL+BREAK or ESC.