>Hi,
>
>My application run fine, but sometimes, my client server hang, causing
>my application processing data to give error as it can't access the data files giving CDX problem.
>
>Is there any ways before my program process data, that I can detect this problem with CDX or DBF that I can auto do a reindex to solve the
>problem. Any suggestions or advise on how to do it is very much appreciated. Thank you.

I agree with Wayne...usually when I have indexes go bad, I don't even get any errors, I just get bad results with the data, so you can't trap anything for that. Here's a suggestion that works in some situations, if you're really having a lot of trouble: put the table and/or cdx in a readonly server directory. Errors will pretty much disappear.

This also may mean a non-structural CDX, and more coding, but it may beat the alternative...