Transactions and MS-Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I generated a TableAdapter using VS.2005 wizard and MS-Access. How do I add
support for Transactions?
TransactionScope on MS-Access is not supported by OleDb provider.

thanks herbert
 
I 've tried use transaction with Access but it don't work. I think there is
no way.
If you found a way so please inform me. :)
 
In the meantime I have found a solution in Brian Noyes' Book "Data Binding
with Windows Forms 2.0, page 63. Highly recommended book.
He creates a partial class to supplement the autogenerated TableAdapter code.
If you replace Sqlxxx by OleDbxx it seems to work with MS-Access.

regards
herbert
 
Back
Top