When to perform this action:
- 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.
From the command line
If you have Microsoft Access installed on the same machine as your GFI product, you will be able to do this from command line. This can be easily inserted in a batch file which will automatically stop the GFI services, and the IIS services, compact the database and restart the services stopped initially.
The command line utility that you should us is:
Msaccess <path to database file>\<database file name> /compact
msaccess "C:\Program Files\GFI\MailEssentials\Data\Reports.mdb" /compact
You can stop and start the required services using the "Net Stop" and "Net Start" commands. You will need to identify the dependant services of the IIS Admin, so that you stop these before the IIS Admin and restart them after the IIS Admin.
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. More information on the usage of the Jet Compact utility can be found at https://support.microsoft.com/en-us/kb/295334
From within Microsoft Access
- Take a backup copy of the .mdb file(s)
- After backing up the file, open each file in Microsoft Access
- Go to the Database Tools tab
- Click Compact and Repair Database
- Exit Microsoft Access
NOTE: It is not recommended to let an MDB file exceed 1.7GB in size