simulate transaction in access database.

[Mr. x]

I know that access database doesn't have transaction, so I cannot run
several lines, such as :
insert into mytable(col1, col2, ...) values(1,2, ...)
.... folowed by the line
insert into mytable(col1, col2, ...) values(2,3, ...)

I need to run saparately each line.

Is there any tricky way to do good simmulation of transaction, and insert
only whether both inserts succeed ?

Thanks

 

[Cheryl Fischer]

Access provides a form of transaction processing with the BeginTrans,
CommitTrans and RollBack methods for DAO in Access (there are also methods
for ADO). You will find much more information and examples in VB Help.