question about transaction processing

[dpdeleon]

I'd like to wrap some of my code into a transaction. I'm using ADO
recordsets.If I call Subroutine A which calls Sub B which calls Sub C and
within each sub I create a recordset like:

Sub A
Set rst = new adodb.recordset
do something with recordset
Call Sub B
End Sub

Sub B
Set rst = new adodb.recordset
do something with recordset
Call sub C
End Sub

Sub C
Set rst = new adodb.recordset
do something with recordset
End Sub

Do I simply place the begin transaction around the code in Sub A or do I
need to create three begin transactions to make sure the data is committed
as a unit.

Thanks