Compacting an Access database

If you do not have Access installed on your system, use the following procedure to compact a file.

To compact an Access database:

  1. Choose Start > Control Panel > Administrative Tools.
  2. Choose Data Sources (ODBC).

The ODBC Data Source Administrator window opens.

  1. Choose MS Access Database and click Add.

The Create New Data Source window opens.

  1. Choose Microsoft Access Driver (*.mdb) and click Finish. The ODBC Microsoft Access Setup window opens.
  2. Click Compact.

A window opens, asking you to locate the Access database file to compact.

  1. Select the IntegrationManager.mdb file and click OK.

The compacting process creates a new Access database file. Name this new file and click OK.


Documentation Feedback