Hi,

I have three CursorAdapters that use ADO. When I update the changes to the database for these 3 adapters, I want to wrap it in a transaction, so if one of the updates fails, I can rollback to the previous state.

So I used the BeginTrans, CommitTrans and RollbackTrans methods on the ADO COnnection I use for the three ADO Recordsets the CursorAdpters use. But calling BeginTrans generates an error stating I can not create anymore transaction during this session.

It seems like each CursorAdapter internally calls BeginTrans and manages his own transactions. This looks fine, but how can we have a transaction over more than one CursorAdapter?

TIA,

Stefan