>>I have been experiencing difficulty with a FoxPro 2.6 application. Occasionally a user will run a screen and it will apparently 'hang'. I have found that reindexing the tables, which are accessed by the screen, seems to solve the problem. Only .CDX indexes are used.
>
>The problem is inevitable because of technical problem i.e. abnormal shutdown,
>
>>
>>What, if anything, can be done to stop this apparent 'corruption' of indexes?
>>
>>If I write a data maintenance procedure, is there a way to test for such 'corruption'?
>
>Depending on the index problem. Some could be fixed with REINDEX only; others needs to totally rebuild the index, as in delete the entire cdx file then rebuild all indexes again.

Jess,
Repeat after me.. NEVER USE REINDEX!! It is a carryover command from the DBASE days.. Instead, you should look at delete tag all and rebuild the indexes from scratch!