Hi!

It is near impossible to collect and determine all cases of corruption and ways to determine them. As a result, many applications use more simple approach for database maintenance. Create an application that will be ran by Scheduler periodically on the server at night hours when nobody use the VFP dtaabase. This application will drop all indexes and re-create them again. The code for re-creating all indexes you can get from the program generated by GenDBC tool for VFP database. In that PRG there are INDEX commands for each table. Creating this application and organizing it periodical running is more easy than trying to figure out all cases of corruption and wayf of determining (detecting) them.

HTH.

>Hi all,
>
>Anyone have ways to detect the above? Appreciate if anyone can advise on this issue.
>
>Thanks in advance.