Overview

Compacting and repairing Microsoft Access database is necessary if one of the following scenarios are encountered:

• A GFI product backend Access database has grown very large.
• A GFI product backend Access database has been compromised or corrupted.

Currently, the GFI products do not perform the compact and repair of the databases automatically.

This article guides you on how to compact and repair the database through a command line and within Microsoft Access.

Process

Compact and Repair from the Command Line

• If you have Microsoft Access installed on the same machine as your GFI product, you can process, compact, and repair from the command line.
• This can be easily inserted in a batch file which automatically stops the GFI services, and the IIS services; compact the database and restart the services stopped initially.
• The batch file can then be scheduled to run during the night, or when email flow is low for example.
• If Microsoft Access is not installed on the same machine as the GFI product, you can try using Jet Compact Utility.

1. Open a command line and use the following command to perform compact and repair.

msaccess <path to database file>\<database file name> /compact

msaccess "C:\Program Files\GFI\MailEssentials\Data\Reports.mdb" /compact