It's an age old question, but how can we prevent indexes of native VFP DBF's from "corrupting"? we have already deployed daily "reindex" tools, but almost everyday corruption happens...

Assuming we cannot resolve network (hardware) concerns, is there no other way to safeguard indexes from network interruption or other external factors that tend to cut connection to dbf server?

Really need a solution for these, we have tried recoding our applications but to no avail.

Thanks.