>Our application that is design from VFP6 always gets in trouble, ;
>It always down because the CDX file always corrupted. All users disappointed since the system in charge always reindex the application. As a >developer, we are doing all our best to capture the reason but still the problem persist. My question is, (How/When/What the reasons) the file CDX gets >corrupted ? and how to prevent it from getting the file from corrupted? We are only using Free Tables.

Holden,

Based on similar experiences I have had, one of the first things I would look at is whether the users are turning off their PCs in the middle of the application. Or whether the app is crashing and the users aren't letting you know about it and just restarting the app (of course this brings up other issues regarding why it is crashing). Are you using views on the free tables with buffering? I found that Foxpro handles the unexpected better when data structures are designed this way.

Others may have more technical ideas on the CDX and it's idiosyncracies, but this may give you some places to start...

Regards, Renoir