>>Hello every body
>>
>>I would like to have some opinions informed on the reliability of the
>>data bases under Fox.
>>
>>We currently use independent tables in networks without major
>>problems, but we would like to use a fox data base.
>>Are the risks of corruption on the .dbc file important?
>>
>>Thank you in advance for your answers
>
>In our company, we have used native VFP tables for 3 years now. We never got a corruption in the DBF files. The indices got corrupted twice, which I solved with REINDEX.
>
>The key factor to reduce data corruption I believe to be using the FLUSH command after every change.
>
>Of course, you should do regular backups, whether you choose VFP tables or a C/S solution.
>
>HTH, Hilmar.

Hilmar;

Good advice. One question. Do you use reindex or recreate the index tags? I prefer the latter as if there is in fact an index that has been corrupted reindex will not solve the problem, at least not for me.

As Sylvain said, use of Stonefield Database Toolkit should be considered as well as a UPS system in case of power failure. Another thing to be careful of is "dirty power" (electrical mains not providing clean power) and "old computer power supplies, which begin producing spikes on the power output and cause data corruption. Statistically, a power supply over three years old can begin to exhibit this problem.

Tom