Microsoft.Jet.OLEDB.4.0 provider

Question

Is Microsoft.Jet.OLEDB.4.0 provider support transactions?

Thanks in advance.

if the answer is yes i would be glad to have a reference for a good example for using begintransaction,commit,   and rollback.

Thanks

Answer 1

Just use the OleDbConnection class methods BeginTransaction, Commit and Rollback.

http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbconnection.begintransaction(VS.71).aspx

Answer 2

Thanks for your help.

i did try the code on the following link: http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbconnection.begintransaction(VS.71).aspx
  but i get the following exception : An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll
Additional information: This OleDbTransaction has completed; it is no longer usable.

this exception occure when : myTrans.Rollback();

Please help me avoid this exception.

Please advice.

Answer 3

Has the transaction already been committed? You can't roll it back if the Commit method has been called.