Cleaning Data Files
The best procedures for cleaning up a your data file.
1. Drop all indexes with Datacheck 1.2
2. Scan with Datacheck 1.2 (No indexes to scan, just records)
a. Find and Fix Gremlins.
b. New audit log of records that were changed is nice.
3. Compact indexless file with Tools to pack the records tight.
Beware of starting step 3 before Tools has finished rebuilding the
indices (indexes - English is *really* stupid at times...)
If you don't wait for the indexes, you stand an extremely good chance of
destroying the data file
4. Open with 4D Server to build new fresh indexes.