Hi John.

>any good routine that we can add to our program to check for the data loss problem while inserting and recovery routine should be to prevent more and more data loss without notice?

Jim gave a snippet of code in this thread that compares the record count with the physical table size. Also, if you upgrade to VFP 8, it will automatically detect this problem and give you a warning.

Doug