>To me, this means that using the OleDb provider is a very bad decision and that should never be used for production site. I am wondering how others are succeeding in using it if it is so buggy.
>

Hi Michel,

Suppose you are getting "Index doesn't match ..." error due to the same reason the error 2066 is reported, which is only a guess at this point. What proposed solution, if any, have you tried to configure your VFPOLEDB connection for very frequently changing data? Have you tried setting second parameter of SET REFRESH setting to very low number or even -1? Have you tried something else?

Thanks,
Aleksey.