A transaction relates to a connection. You can open as many recordsets as you want on that connection and you will see the changed values. As long as the connection is open, you won't feel the difference. Once you close the connection, the transaction will be rolled back if it has not been explicitly committed.