>>Is there a product or technique that would allow for policing curruption (database, tables, etc) in an application without having to handle them as a support call by the user. I have't invested in any 3rd party product yet, but am being killed by the frequency of having to recover something related to data several times a day (pc lockup, VFP freezing etc).
>>
>>Is the developer community being plagued with data curruption problems in the real world or am I missing an important piece of information.
>>
>>Any solutions or advice would be greatly appreciated!
>>
>>Thanks,
>>
>>Gary Pike.
>
>There are several old public-domain samples of file header and memo file repair utilities. In my app, all DBF's are checked for corruption when the app is started. If a damaged file is found, an improper shutdown screen appears and the app offers to fix the damaged files (using the samples from public-domain).
>
>This seems to fix damaged files 99.9% of the time.
>


However, if your getting freezes and lockups all the time. Either there are hardware problems, or you are doing something wrong. Lockups should be VERY rare nowdays with modern hardware. Make sure you have good network wiring and make sure your systems have the latest service packs and such on them. With all our customers, we seldom see or hear of lockups, and when we do they usually don't do much if any damage to things.