access 2003 and transactions commit-rollback

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
MDB with Access 2003 Jet.
For speed of development I would like to use the built in save and delete
data routines automatically associated with forms. However I also want to
wrap these as transactions. Is there any way to find or set the connection
cursor used by the built in routines to allow me to issue the begintrans and
endtrans statements? I would then hook into the save and delete events and
issue the begin and end trans statements. I would prefer not to have to write
the save and delete processes when its all done for me.

Hope this is clear :-)

Madhouse
 
Access does not expose the built-in transactions for forms..

In A2000 and later, you can open a recordset inside a transaction, and then
assign it to the Recordset of a form. The forms changes are then inside your
own transaction.

This does not work for subforms, since Access reloads the subform every time
the main form changes records. It's also fairly easy to get some instability
this this approach.
 
Back
Top