>I only have a few installations with VFP. I occasionnaly have problem with index but not too many.
>Nevertheless, I am confronting some people right now that tell me that they definitely don't want fox around because they used to have a lot of indexes problems ("Always corrupted...","...have to reindex every days...", and so on...
>I don't know what to tell them...
>Is it true ? Is there particular situations where there are more chances to get corrupted indexes ? Is there any ways to avoid corrupted indexes ? How frequently do we have to run reindexes ? How can we tell when to run reindexation (before errors occurs) ?
>Do we have less chances corrupting the indexes if we update with SQL commands ?
>
>Is it why a lot of people are going the client-server road ?
>
>
>Thanks for any comments on this.
>
>
>Eric


There are two main problems of index corruption:

1) Network. This can be anything from bad cabling to drivers.
2) Bad application design. Using buffering and views definately reduces the possibility of corruption.