Cetin,

I was long under the impression that the ADO recordset gives me more control on its properties and deeper understanding of what is going than the cursor adapter (in VFP).
Now, when I am required to work in VB.NET instead of FoxPro, I try to use the same concept (especially when the code has already been developed in FoxPro, proved to work nicely there, and it seems easy to use the code directly in VB.NET with minor syntax changes).

It looks like I do not have this option anymore. In VB.NET, besides the problem with the recordset.source, I am not able to update VFP table. With both, recordset.UpdateBatch or Update, either there are no errors, or the error description is confusing:

“Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.”

Because updates work properly for the “selected locktype” in VFP and VB, then I assume that it is the “limitation of the provider”.

Looks like I need to use the Data Adapter here anyway.

I will appreciate your opinion.

>Yes,
>had problem in setting .source. I don't know if it's a bug or not and honestly didn't even think to use ADODB in .Net until seeing your question.
>Cetin