The Reindex option
Description

The Reindex option is used to fix corruption and other problems, for example missing records within modules.

Each data file has a matching index file which tells the software what order the data should be in. Sometimes these files don't match up and the order of your data may appear incorrectly. The Reindex option writes all of the record information from the relevant module you choose to a new index file and then replaces the original index file with the new one.

It's a simple process to follow, let's take a look.

If you've any errors, warnings or comments, you may need to use the reindex option as part of your solution. For full details of how to repair data, refer to the following articles:


Cause
Resolution

Reindex your data

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

  1. Before you reindex your data, take a backup of your data.
  2. Click Help then click About and under Data Information make a note of the number of Splits.
  3. On the menu bar click File then click Maintenance then click Reindex.
  4. Select the relevant files to reindex then click OK then click Yes.

TIP: In Sage 50 Accounts v28.1 and above, there is now an option to reindex the VAT files which was not 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'.

  1. If you're following a routine for fixing certain errors and are not advised to compress, click Close, otherwise click Compress Now
  2. Clear the Compress All Data Files check box, then clear the required check boxes except the module you've reindexed.
  3. Click Compress then click OK then click Close then click Close.
  4. Click Help then click About and under Data Information ensure the Splits matches the number you noted in step 2.

    If it doesn't, please check your data. To fix any errors that are found, please visit www.sage.co.uk/mydata
[BCB:101:Limitless - 50 Accounts - Data Corruption / Maintenance:ECB]
Steps to duplicate
Related Solutions