The operation of our main app involves the distribution of free FoxPro tables across our WAN. For reasons yet unknown, the data sometimes suffers corruption. Randomly, character field data will be replaced by chr(0).

Q1: Does anyone have experience with this problem?

We have recently encountered a corrupted table which FoxPro would happily open but unfortunately would not handle properly. It appears that we can't reliably detect this problem using FoxPro code.

Q2: What would be the best means of handling this kind of damage?

Thanks