Begin Tran open disconnected recordset - reconnect - rollback/comm

Is is possible to commit or rollback under the following circumstances using
ADO?

1. Begin a Tran on a database
2. Open a recordset and disconnect it
3. Perform multiple operations on the disconnected recordset
4. Reconnect and updatebatch on the recordset with adMarshallAll (default)
5. Filter (ModifiedRS.Filter = adFilterConflictingRecords)
6. When ModifiedRS.recordcount>0
6a ROLLBACK initial Tran from step 1.
7. Whne ModifiedRS.recordcount=0
7a COMMIT initial Tran from step 2.

Given above sequence, if Rollback or Commit is completed
A) Will TRANSACTION effect the updatebatch condition given that the record
was opened after the Begin Tran?
OR
B) Will the fact that the recordset is disconnected mean that the
commit/rollback tran will not effect the records from that batch?

.

Relevant Pages

  • RE: Query SQL Server
    ... disconnect each time it calculates. ... What you really need to do is use an ADO disconnected recordset in VBA. ... connection while saving the recordset (and the query results). ... > The PartNo column contains values that a user has entered. ...
    (microsoft.public.excel.programming)
  • Re: sql question
    ... > begin tran ... > together to enable the rollback if the data being changed it not ... command to SQL Server and then commit or rollback as needed. ... In the first batch, you issue a BEGIN ...
    (microsoft.public.sqlserver.programming)
  • Re: Displaying thousandths in SQL Server datetime fields
    ... Or "rollback tran" if you do not want to commit it:) But do not neglect doing either one of "rollback tran" or "commit tran" otherwise you may have issues. ... And in the Query Editor you can add a BEGIN TRAN at the beginning so if you ran the statement and the rows affected wasn't what you expected you can roll it back and try again. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: commit or rollback a transaction without first beginning a transaction
    ... what happens with a Jet recordset. ... > SQLTransact function is called to commit or roll back the transaction. ... > "The Microsoft Access driver supports active transactions. ...
    (microsoft.public.access.modulesdaovba)
  • Re: DBD::Sybase and auto commit
    ... >> rollbacks into the stored proc. ... >> EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. ...
    (perl.dbi.users)