Use the Reindex option to fix corruption and missing records.

Each data file has a matching index file that orders the data. If they don't match, the data can appear incorrect. Reindexing writes all record information to a new index file and replaces the original.

If you have errors, warnings, or comments, reindexing can be one of the steps to resolve then. Visit our errors, warnings, or comments in my data article for more information.

Reindex your data

 CAUTION: If you use Remote Data Access in v27, we recommend you use the Reindex option at the main site.

1. Before you reindex your data, take a backup of your data.
2. Go to Help then About and note the number of Splits in the Data Information section.
3. Go to File, then Maintenance, then select Reindex.
4. Select the relevant files to reindex then select OK, then Yes.

TIP: In Sage 50 Accounts v28.1 and above, there's now an option to reindex the VAT files which wasn't possible in earlier versions. Install now.  

When the reindex is complete, the following message appears: 'After re-indexing, it is advisable to run the Compress Data routine, to reclaim disk space used by deleted records'.

5. If reindexing to fix errors or warnings, follow the advice to compress and select Compress Now. If not advised to compress, select Close. 
6. Clear Compress All Data Files, then clear all check boxes except the modules you've reindexed.
7. Select Compress then OK.
8. Select Close then Close again.
9. Go to Help then About and check the number of Splits in the Data Information section.

Number of Splits

• Match the number noted in step 2 - the process is complete and you can back up your data
• Differ to the number noted in step 2 - run the Check Data again and fix any errors found. Visit www.sage.co.uk/mydata