>Hello,
>
>At one client it happens very frequently that the index of some tables gets corrupted.
>
>My guess is that the network connection is not very stable, but they checked the connection and say there should be no problems with the network.
>
>Yesterday a table got corrupted with the message (when appending a record):
>
Index file "c:\Cinemas\transactions.cdx" tag "Trusedt" is corrupted. Please rebuild it."
>
>After that we suggested to run the program locally on the computer. I issued a REINDEX and they worked again. After 20 minutes the same message appeared.
>
>Then I deleted the CDX file and created the indexes again. That seemed to have helped, but I am not sure what causes this problem.
>
>The other strange thing is that this program does not alter the field Trusedt.
The fact that you don't alter this field doesn't matter, IMO - if records are added, all indices have to be updated.
Assuming there really is a network problem, several indices might get corrupted.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)