>Thanks Edward,
>
>The problem is that the application is dealing with multiple tables having several
>hundred thousands of records so systematically reindexing is not a valid
>option for me.
>
>Ever seen this kind of corruption before?
>
>Pascal
Firstly, you can run this program overnight. Also, foxpro indexes are stable enough and should not get corrupted for a long time. If you have consistent corruption problem, it indicates network problems like server breakdowns, etc. and solution should be found on this side.
Edward Pikman
Independent Consultant