Sage 50 Accounts hangs or crashes during Check Data
Description
Cause
Resolution

 NOTE: Follow our separate article, if the message 'Check Data Files was aborted' appears. 

Run Check data within Demo Data

  1. Close Sage 50 Accounts.
  2. Open Sage 50 Accounts and open the Demonstration data company.
  3. Enter Manager as the login name, click OK.
  4. Go to File, select Maintenance, then select Check Data.

If the issue also occurs in Demo Data, check and remove any old report files.

Browse to the following directories;

Sage Accounts v32-C:\ProgramData\Sage\Accounts\2026\Company.000\Reports
Sage Accounts v31-C:\ProgramData\Sage\Accounts\2025\Company.000\Reports
Sage Accounts v30-C:\ProgramData\Sage\Accounts\2024\Company.000\Reports
Sage Accounts v29-C:\ProgramData\Sage\Accounts\2023\Company.000\Reports
Sage Accounts v28-C:\ProgramData\Sage\Accounts\2022\Company.000\Reports
Sage Accounts v27-C:\ProgramData\Sage\Accounts\2021\Company.000\Reports
Sage Accounts v26-C:\ProgramData\Sage\Accounts\2020\Company.000\Reports

Select COMMENTS.RPT, ERRORS.RPT and WARNINGS.RPT, right-click, then select Delete.

If the issue still occurs in Demo Data, uninstall and reinstall the Sage Accounts software.

If the check data completes in demo data, click Next.

Check that the settings and data directories aren’t hidden or read-only
  1. Help > About > in the Program Details area, make a note of the Settings directory and the Data directory.
  2. Browse to the Settings directory.
  3. Right-click on the folder for your version > Properties > clear the Read-only and Hidden check boxes > Apply.
  4. Select Apply changes to this folder, subfolders, and files > OK > OK.
  5. Browse to the Data directory > repeat steps 3 and 4.
Reindex and Compress the relevant module and clear the audit trail to 01/01/1980

 NOTE: Before changing the data, take a backup of the data files. For more information about how to back up your data.

Make a note of the area being checked when Sage Accounts hangs or crashes. The following table advises which areas to ReIndex and Compress:

Before running the reindex and compress routine, make a note of the number of splits. This equates to the number of lines of transaction information in the data. To do this:

  • Help > About > Data Information > note the number of splits

After the reindex and compress routine, check the number of splits again; if the number has changed, the data hasn’t been fixed, and you’ll need to either restore an error-free backup or arrange for the data to be repaired at Sage. For more information about sending your data in for repair, contact Sage technical support.

Area in which check data hangs or crashesAreas to ReIndexAreas to CompressTransaction Link Integrity

Ledger Transaction Links

Customer Accounts

Supplier Accounts

Nominal Accounts

Bank AccountsAudit Trail

Customer Accounts

Nominal / Bank Accounts

Supplier AccountsAudit Trail

Sales Ledger

Purchase Ledger

Nominal Ledger

Bank AccountsStock RecordsStock RecordsProductsInvoice RecordsInvoicesInvoicesPrice ListsPrice ListsPrice ListsSOP RecordsSales Orders

Goods Despatched NotesSales Orders

Goods Despatched NotesPOP RecordsPurchase Orders

Goods received NotesPurchase Orders

Goods received NotesGood Received NotesPurchase Orders

Goods received NotesPurchase Orders

Goods received NotesProject RecordsProject Records

Project TransactionsProject Ledger

To ReIndex and compress the data and clear the audit trail to 01/01/1980
  1. File > Maintenance > Reindex data files.
  2. Select the relevant files to reindex using the table above > OK > when the confirmation message appears, click Yes.
  3. Compress Now > clear the Compress All Data Files check box > select the relevant files to compress using the table above.
  4. Compress > OK > Close > Close.
  5. Tools > Period End > Clear Audit Trail > Next.
  6. Enter 01/01/1980 > Next > Next > Exit.

If the issue still occurs or the ReIndex and Compresses option hangs this indicates the data is corrupt. We recommend that you restore a backup of your data before the issue occurring. For more information about how to restore your data.

As a last resort you can send your data into us to be fixed. When we repair data it may involve removing several transactions; however, we may not be able to provide details of the removed transactions. Also stop processing during the repair. If you restore a backup, it may result in less time to reprocess the transactions compared to sending the data in.

For more information about sending your data in for repair, contact Sage technical support.

[BCB:281:UKI Wizard:ECB]
Steps to duplicate
Related Solutions