Transactions in Access 2000

Hi.

I need to use transactions to make sure data is consistent. I have a
combo box that when changed to a new value updates a table. I then
have a DoCmd.RunSQL statement following that in the same Sub. I would
like for it for those two things to be wrapped up in one transaction,
with the user being informed that a transaction has rolled back.

I have not implimented transaction in Access so code bits would be
helpful to me. I am also trying to avoid using any References like ADO
as to make the db as portable between Access versions greater than
2000.

Thank you in advance.

.

Relevant Pages

  • Re: Recordset.AddNew and the recordset objects data retaining
    ... via an ADO recordset, then I'd strongly suggest you redesign your solution. ... > to do with the updates being in a transaction but rather on whether you specify ... > spill over and the memory starts paging out to disk that concerns me). ...
    (microsoft.public.data.ado)
  • Re: v$transaction.cr_gets
    ... Is it all consistent gets for the transaction? ... that required rolling back a change from the undo segment listed in the ... So is this all the logical I/O, or just the logical I/O needed ...
    (comp.databases.oracle.server)
  • Re: buffer cache and Rollback
    ... specific RBS specified in the transaction slot of the updating transaction, ... layer of the onion by reconstructing read consistent images until the block ... A rollback/undo block is just another block, if it's in the buffer cache ...
    (comp.databases.oracle.server)
  • Re: v$transaction.cr_gets
    ... Jonathan Lewis wrote: ... Is it all consistent gets for the transaction? ... So is this all the logical I/O, or just the logical I/O needed ...
    (comp.databases.oracle.server)
  • Re: Undo
    ... consistent gets from cache ... transaction tables consistent reads - undo records applied ... Below is the doc from oracle in the performance tuning guide on ... This is called delayed block cleanout. ...
    (comp.databases.oracle.server)