Overview
GFI LanGuard enables you to repair and compact the Access Database backend automatically to improve performance.
During compaction, the database files are reorganized and records that have been marked for deletion are removed. In this way, you can regain used storage space. During this process, GFI LanGuard also repairs corrupted database backend files. Corruption may occur for various reasons. In most cases, an Access database is corrupted when the database is unexpectedly closed before records are saved, e.g., due to a power failure, unresponsive operations forced reboots, etc.
Process
- Launch GFI LanGuard.
- Go to Configuration > Database Maintenance Options > Database Maintenance Plan.
- Select the Advanced tab. Choose the appropriate action needed from the list of options on the table below:
Options Descriptions
Compact Now To manually launch a repair and compact process on the Access database backend.
Database compact and repair frequency One time only To schedule a one-time Access database repair and compact.
Every: To execute a repair and compact process on a regular schedule. Next operation Specify the date, time and frequency in days/weeks or months at which the compact and repair operations will be executed on your database backend.