Thanks for testing it Cetin. It is a holliday here today (Memorial Day) so I'll try to contact Advantage tomorrow.
Einar

>I used your code. Only changed 3 things:
>1) Connection string.
>2) MessageBox.Show inner text - just used String.Format instead
>3) Placed another messagebox before delete call so I would have time to insert another from outside.
>Cetin
>
>>Cetin,
>>Thanks for testing it using VFP. Did you use "my" code? If you used similar code to mine then it must mean that the ADO.NET transaction is not available with the advantage oledb provider. I'll check with Advantage to see if they have a newer version of the provider than me.
>>
>>Einar
>>
>>>Einar,
>>>It worked for me as it should (using VFPOLEDB, not advantage). Records were not deleted.
>>>Cetin
>>>
>>>
>>>>This message is not nessesarily to Bonnie, since she will not be replying for another 6 weeks <s>
>>>>
>>>>I took Bonnies' advice and used a transaction, but it isn't working like I would expect. In order to test this I put in a break point after the Fill() and then quickly added another record to the table before the delete executed. This resulted in a selected and deleted row count mismatch and a rollback was issued on the transaction. Now I went back into the table and found that there were no rows in the table!! They should still be there because I did a rollback!!
>>>>Anywho is it possible that the database server does not supprt this rollback feature or is this rollback feature a pure ADO.NET feature and the backend database does not matter?
>>>>
>>>>I posted the code I am using, just in case I made some crazy mistakes.
>>>>
>>>>Any information on transactions in 2.0 is welcome.
>>>>
>>>>Thanks,
>>>>Einar
>>>>