Compress/Repair Database

This command will compress or repair the database reducing its file size. With time and usage, the file size of the database will increase in size. In part, this is due to the creation of temporary tables when reports are run. It is a good idea to compact the database on a monthly basis. You will need exclusive access to the database in order to perform this function.

1. Select the Compress/Repair Database from the Main Tools Menu.  This will automatically close any open tables.
2. Reopen your database file by supply the UserName and password when prompted.
   
   

Repairs may be required if TrackPro is closed unexpectedly because of a power outage or computer hardware problem. Normally, the database won't be marked as possibly corrupt if you quit TrackPro in a usual way. You will need exclusive access to the database in order to perform this function. If the TrackPro database behaves unpredictably, perform this action.

The Repair Corrupt Database method also attempts to validate all system tables and all indexes. Any data that can't be repaired is discarded. If the database can't be repaired, an error occurs.  When you attempt to open a corrupt database, an error usually occurs. In some situations, however, a corrupted database may not be detected, and no error occurs.