>Again, thank you for bringing up the UseTransactions property. The default value for this property is .T. and I never touched it in my CA object. And the VFP help says
>
>

>The settings for the UseTransactions property are:
>
>Setting  Description  
>True (.T.)
> (Default) The CursorAdapter uses transactions when sending Insert, Update or Delete commands through ADO or ODBC.
> 
>False (.F.)
> The CursorAdapter doesn't use transactions when sending Insert, Update or Delete commands through ADO or ODBC.
>

>
>And since I do use Transactions through ODBC, why would I need to set this property to .F. ? Unless I misunderstood what you were suggesting.

I've really never used CursorAdapters, but did use SQLEXEC() commands, so I thought that if one must use SqlSetProp() with the parameter "2" to activate maunal transaction, then may be this is the same with CursorAdapters with this property. But I really don't know and just wanted to let you know about it.