Transactions and closing recordsets

[paii, Ron]

I have a series of recordset operations, Open/Edit/Close, Open/Edit/Close. I
want to wrap in a transaction. What happens to the edits when the record set
is close before the Commit or Rollback? Do I need to keep all the recordsets
open?

[Allen Browne]

No. Close the recordset, and set it to Nothing as soon as you are finished.
These edits exist in the workspace that you will utlimately commit or
rollback.

This article illustrates a series of steps that are ultimately
committed/rolled back, and discusses the traps:
Archive: Move Records to Another Table
at:
http://allenbrowne.com/ser-37.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"paii, Ron" <pa**@packairinc.comwrote in message
news:_d******************************@athenet.net. ..

>I have a series of recordset operations, Open/Edit/Close, Open/Edit/Close.
I
want to wrap in a transaction. What happens to the edits when the record
set
is close before the Commit or Rollback? Do I need to keep all the
recordsets
open?

[paii, Ron]

Thank you for the quick response.

That's good to know, I normally run a series of actions query, but this
function's logic was easer with recordsets.

"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:46***********************@per-qv1-newsreader-01.iinet.net.au...

No. Close the recordset, and set it to Nothing as soon as you are

finished.

These edits exist in the workspace that you will utlimately commit or
rollback.

This article illustrates a series of steps that are ultimately
committed/rolled back, and discusses the traps:
Archive: Move Records to Another Table
at:
http://allenbrowne.com/ser-37.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"paii, Ron" <pa**@packairinc.comwrote in message
news:_d******************************@athenet.net. ..

I have a series of recordset operations, Open/Edit/Close,

Open/Edit/Close.

I
want to wrap in a transaction. What happens to the edits when the record
set
is close before the Commit or Rollback? Do I need to keep all the
recordsets
open?