Transaction Problem

[Guest]

Hi experts

I have a c# windows form with a datagridview. When I add a new record, it
does not immediatley appear in the datagridview, however, if I step through
the code it does. It also does if I sleep the code for 10 seconds.

The code is adding data to 2 tables in an access database and there are 2
ExecuteNonQuery statements. I wrapped these into a transaction using the
Connection.BeginTransaction(IsolationLevel.ReadComitted).

The error I get now is 'OleCbConnection does not support parallel
transactions', and when I click ok, the record appears immediatley in the
datagridview.

Any ideas, should I use 2 connections?

Thanks

 

[Nicholas Paldino [.NET/C# MVP]]

It's hard to say without seeing the code. Can you show the code where
you get the connection, start the transaction, and insert the record?