You can use the repair and compact options in Sage 50 Payroll to compact the size of your database and to reduce the size of your backups. This routine also helps to tidy up your data and resolve and prevent data corruption. We recommend running the routine once a month. 

You can also use the repair procedure if Sage 50 Payroll can't read your employee database. For example, if you're processing your payroll and an error message appears.

Examples of error messages:

• Cannot connect to Database
• Failed to Update
• Pay5

The Repair option repairs and compacts the data. You don't need to run the Compact procedure separately.

Things to check

• Check you're running the software as an administrator
• Check Windows permissions and antivirus software

Repair your data

1. Close Sage 50 Payroll.
2. If you have a multi-user licence, ensure any other users log out of the company you want to repair.
3. On the Windows desktop, right-click your icon for Sage 50 Payroll.
   
4. Click Open File Location.
5. Locate and double-click DBUtilities.exe.
6. Select the required company, then click Clear Locks.
7. Click OK to confirm no other users are logged in.
8. Click Repair. When this completes successfully. click Repair again to complete a second repair.
   NOTE: If the first repair fails, click OK, then click Repair to try again.
9. Click OK, then click Close.