>Hi all,
>
>I have a web app that relies on VFP data and it runs 24/7. Sometimes, an index entry for a particular record in a table would be corrupt so the code that uses IndexSeek() function cannot find the record. It would be costly for our clients to take the server down to reindex the database frequently.
>
>How do you guys repair the index without taking down the whole system?
>How frequently does this kind of index corruption happen to your data?
>
>Any comments, suggestions will be greatly appreciated.

Hi Dawa,

Could you provide more details about the scenario? Does IndexSeek() fail to find record added/modified by the same client or by some other client? Is the record added/modified recently?

Thanks,
Aleksey.