Which Object to use for the Transaction process

[raabbasi]

One of my routines calls a number of functions, each of which return True in case of 'Succes' and False in case of 'Failure', as below:

Private Sub SubXmple()
Obj.Begin Trans
if Update_tblA = False then Goto lblRollback
.......
if Update_tblB = False then Goto lblRollback
.......
if Update_tblC = False then Goto lblRollback
.............
Obj.CommitTrans
Exit Sub

lblRollback:
Obj.Rollback
End Sub

My problem is that some of the called functions use a hybrid of the DAO and the ADO recordsets. In such a case which Object should I use (and how can I implement the Transaction process).

Any help will be highly appreciated.