Skip to content
logo Knowledgebase

Sage 50 Accounts hangs or crashes during check data

Created on  | Last modified on 

Summary

How to resolve hanging or crashing when you run the Check Data option in the Sage 50 Accounts.

Description

NOTE:

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

 

Resolution

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 then 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.

  1. Browse to the following directories:
Sage Accounts v33 C:\ProgramData\Sage\Accounts\V33\Company.000\REPORTS
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
  1. Select COMMENTS.RPT, ERRORS.RPT and WARNINGS.RPT, right-click, then select Delete.
Next

Check that the settings and data directories aren’t hidden or read-only

  1. Go to Help then About, then make a note of the Settings directory and the Data directory in the Program Details section.
  2. Browse to the Settings directory.
  3. Right-click on the folder for your version, select Properties and clear the Read-only and Hidden checkboxes.
  4. Click Apply.
  5. Select Apply changes to this folder, subfolders, and files, click OK, then OK again.
  6. Browse to the Data directory and repeat steps 3 to 5.
Next Back

Reindex and Compress the relevant module and clear the audit trail to 01/01/1980

 

NOTE:

Before changing the data, back up your data files.

 

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:

  • Go to Help then About. Note the number of splits in the Data Information section

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 crashes

Areas to ReIndex

Areas to Compress

Transaction Link Integrity
Ledger Transaction Links
Customer Accounts
Supplier Accounts
Nominal Accounts
Bank Accounts

Audit Trail
Customer Accounts
Nominal / Bank Accounts
Supplier Accounts

Audit Trail
Sales Ledger
Purchase Ledger
Nominal Ledger
Bank Accounts

Stock Records

Stock Records

Products

Invoice Records

Invoices

Invoices

Price Lists

Price Lists

Price Lists

SOP Records

Sales Orders
Goods Despatched Notes

Sales Orders
Goods Despatched Notes

POP Records

Purchase Orders
Goods received Notes

Purchase Orders
Goods received Notes

Good Received Notes

Purchase Orders
Goods received Notes

Purchase Orders
Goods received Notes

Project Records

Project Records
Project Transactions

Project Ledger

To ReIndex and compress the data and clear the audit trail to 01/01/1980

  1. Go to File, then select Maintenance, then Reindex data files.
  2. Select the relevant files to reindex using the table above then click OK.
  3. When the confirmation message appears, click Yes.
  4. Select Compress Now, clear the Compress All Data Files check box, then select the relevant files to compress using the table above.
  5. Click Compress then OK.
  6. Click Close then Close again.
  7. Go to Tools, then select Period End.
  8. Select Clear Audit Trail then Next.
  9. Enter 01/01/1980, select Next, then Next again.
  10. Select 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.

RestartBack