ust to continue on this line of thought. There are actually two
co-dependent connections in the legacy application [which used DAO]. It tied
the two together using a Workspaces object that was ODBC bound to an ACCESS
database through table linking with many tables from the SQL Server 7.0
databases. The queries ran through this ODBC connection channel and the
rollback was only through the single ODBC channel.
While I can still follow the rule to open the connection and rollback
depending on the presence of the COM exception - I suspect that for this
case, what must happed is this - Establish a connection for each recordset,
maintain both, begin tran on both, and commit or rollback depending on
whether one or each of them has a COM exception.
Is this correct?