Transactions and sub Procedures

[Diarmuid]

Ok, I want to set up a DAO transaction, which I have in my main procedure.
But if I call sub procedures, any updates there won't be included in the
transaction. I'd like to include the sub procedures, as I may need to
rollback the whole lot.
And advice on how I would do this?
Thanks
Diarmuid

 

[Michel Walsh]

Hi,


In a complex transaction, where many components are involved, like
database AND objects in memory, a possible solution is to use some kind of
transaction manager that will commit or rollback each components
appropriately. COM+ has such transaction manager, but that is probably an
overkill. If all the modifications occur in a single database, use the SAME
database object if you want to include all the modifications in the
transaction. You have to organize your database object scope of existence
appropriately, and that SHOULD be a piece of cake.


Hoping it may help,
Vanderghast, Access MVP