This feature is used to prevent and fix database corruption. It should be run regularly for sites that are using Access network databases and have a high call volume and run periodically for all other sites using Access network databases. It is not used with SQL Server network databases. This option will also allow you to repair and compact any other database that is using Access, such as archives, or your local database. The repair attempt to fix data corruption errors, while the compact removes extra space in the database, which helps improve database performance by shrinking the database size.
To run a repair and compact, select this option from the Tools menu. Then choose the appropriate database from the dropdown window. It is recommended that you also check the Compact and the Create Backup checkboxes before running the repair and compact. As stated above, the compact allows the database to try to maximize it’s performance. The backup creates a backup file with the same filename as the database you are fixing with a .SAV extension. For example, if you were performing this on the network database, Toxinet.mdb, the backup file would be Toxinet.SAV. Each time the repair and compact is run, the previous .SAV file for that database will be overwritten with the new backup information.
Please be aware that when the backup option is checked, TOXICALL® will need twice the file size available as free space. If you run it without that required space, it will not complete successfully. If you do not have enough space you can run the repair and compact without selecting the Backup option, but it is highly recommended that you create a backup copy of your database elsewhere before performing this operation. If you choose to run without the Backup option, a warning message will appear reminding you to be sure you have a current backup available.
When you have completed these steps, click the Run button. A message will appear asking if you are sure you want to compact and repair, click Yes. If it completes successfully a message box will appear stating this. If you get an error, please see Database Corruption under the Troubleshooting section in this manual.