>Michel I would recomend that you start using transactions if you are not using them already, and then play with the SET reprocess command, I'm assuming that when you create your sql connection you initialize it with a bunch of set commands, at least that is what I do when accessing any VFP data.
No, I didn't have to do anything like that so far.
At this point, I don't know if that is related to the bug in the VFPOleDB data provider. From all the work we have done on that with Microsoft, it was only related to the connection design. Once the connection is done and reuse, that bug was not suppose to come back after. I don't know if that could be related here.