If you are able to open AbacusLaw by CARET

Reindex

1. Have all other users exit AbacusLaw by CARET, MessageSlips, and Abacus Accounting.
   
   
2. Navigate to File > Utilities > Reindex.
   
   
3. After the reindex has completed, try the same action that caused the error again.

If you are NOT able to open AbacusLaw by CARET

Delete ADI Files

1. Have all users exit AbacusLaw by CARET, MessageSlips, and Abacus Accounting.
   
   
2. Navigate to the Abacus root directory (e.g., \Abacus\v23\data01\).
   
   
3. Click the dropdown on the Type column, and check the box next to ADI file, so that only files of this type are displayed.
   
   
4. Delete all *.adi files.

Be sure that you delete all files ending in ADI, and NO OTHER FILES. ADI files are index files, and do not store data. Other database files (ADTs and ADMs) store actual data and deleting them will delete your database!

If you are running AbacusLaw by CARET v23.16 or earlier, also delete all .cdx files, but DO NOT delete any .dbf or .fpt files.

The next time AbacusLaw by CARET is started, it will recreate the index files and should function normally.

Identify the Expressions in Each Report

1. Select File > Reports and choose a section.
   
   
2. Select a report from the list and click Edit.
   
   
3. The Edit Report window opens. Click Index.
   
   
   
   
4. The Edit index properties window opens. If the Expression field is populated, record the name of the report and the expression.
   
   
   
   
5. Repeat this procedure for all reports.

Add User-Defined Indexes for Each Unique Expression

This step requires all users to be out of the system.

1. Select File > Setup > User Indexes.
   
   
2. The User-defined Indexes window opens. Click Add.
   
   
   
   
3. The Index Properties window opens.
   
   • For Database, select the table the index will be used for.
   • Enter the Index name.
   • For Index key, select the field that the expression calls for.
   • Leave Condition blank.
   • Click Done.
     
     
     
     
4. In the window that appears, click Yes. The tables will be reindexed.
   
   
   
5. Repeat this step for each unique expression.

Change the Reports to Use the New Indexes

1. Select File > Reports and choose a section.
   
   
2. Select a report from the list and click Edit.
   
   
3. The Edit Report window opens. Click Index.
   
   
4. The Edit index properties window opens. Remove the expression and select the corresponding index created in the previous step.
   
   
   
   
5. Click Done.
   
   
6. Repeat this procedure for all reports with expressions.