Eric,

>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 ?

I've got tenths of VFP systems running for over a few years, and only have discovered 1 index break in 2 years (VFP5 app). I tend to believe index corruption is rare when:

1. Using a stable network (prefferable not Novell)
2. Use buffering and transactions for your updates.
3. If the system is used my multiple users, even a workstation powerfailure rarely causes any problems (Because opportunistic locking is turned off).

That said, i think 95% - 99% of the index corruptions belongs to the past. VFP 6 is far more stable than the old xBase apps...

Walter,