DB Transaction use in Access 2000/3: Significant example sought

[Guest]

I'm developing an Access app in which I must simultaneously modify three
different tables, ensuring that either all three tables are modified
"simultaneously" or none is. Is there a way to do this without using
recdordsets? I've done quite a bit of DB transaction processing on another
platform using SQL and PL/SQL but that other platform doesn't use DAO, or
ADO, or recordsets by that name. Are there any sample applications of the DB
transaction concept in the MS DB templates? If not, does anyone know of a
good publicly available example?

 

[Douglas J. Steele]

For an example using DAO, see
http://www.blueclaw-db.com/vb_transaction_processing.htm

For an example using ADO, see
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthbegintrans.asp (or,
more precisely,
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthbegintransx.asp )

 

[RD]

For an example using DAO, see
http://www.blueclaw-db.com/vb_transaction_processing.htm

<snip>

Nice example. Thanks for that!

RD