Re: Transactions across several subroutines

jonefer wrote:
I'd like to start a transaction a 'New Record' button on my MS Access
form and then End the transaction several pages later after adding
many children records.

It creates a parent - core record first and has a 'continue' button
so that the user can be directed to a different tab on the form.

On that tab are several 'Add buttons' along with more textboxes to add
children records.


At this point, the transaction would still be going. I thought of
having a module level variable to keep tabs of if a Transaction
started (from the first routine).. is this the appropriate way to do
it?...

Having just started this concept, I haven't seen any examples out
there that show outside routines taking place while a transaction
from another routine has started. Could someone show me an example
of the structure with using the first connection, in this case
CurrentProject, all the way through to the commit or rollback?

Not sure what this has to do with ADO - it seems more of an Access VBA
question. You should post it to an Access group. look in the table of
contents under "Office Solutions"
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.