My app requires that records be inserted into two distinct databases and, if there is any error in either, the actions be rolled back for both.

The first oledb transaction function (trnNew) works fine for one connection, but throws an error when it encounters reference to the second function (trnNew2).

Does anyone know how to include both connections within a single transaction?

Thanks.

Larry