When using Microsoft Access databases it is often necessary to perform a repair and compact on the database.  This can be accomplished through the Access Control Security Application and will appear under the Backups and Archives menu item.  If the database type is Microsoft SQL Server, the Repair Databases tab will not appear.

  • Click Utilities, Backups and Archives menu from the Access Control Security application.
  • Click the Repair Databases tab.
  • Click the Compact and Repair Databases button.  Please note this will close any network clients connected to the database files.

If your database is corrupted and does NOT allow you to run Symphony AC, then you can run the Data_Repair_Compact Utility located in the Symphony AC folder.  You can also download the utility from the link below: Data Repair Compact Utility