>I notice there are several tools out there to fix corrupted tables. Anybody have any suggestions as to which one works best in VFP 5.0? Do any of them fix a corrupted database in VFP 5.0? Are any of them written in code that we can run from within our application, allowing us to automatically fix the tables without any user interaction? Any help would be appreciated. Thanks

Hi Gene,

About two weeks ago I had the same thought when a user from a distant state reported me a typical error that is consequence of a table corruption. Then I imagined the system being capable of detecting those errors and fixing them automatically. I began to have a look over some tools (specially those available in the files section) that deal with these things.

But, as I understood, when there's a table corruption usually you've got also some damaged records. So it's not only a matter of fixing the table header - that only makes the table USEable again. And what about the damaged records? Someone should at least open and browse the table to have a look at it... And what about referential integrity? Things seem to be more complex, don't you think?

However, one day we will surely reach the point of developing "self-curable" systems...

Anyway I would be glad to know your conclusions and also if you find out something interesting on this issue...

Regards,

Renato