I am using VB 6.0 to access Microsoft Access 2003 database using DAO.
I want to insert record into 3 tables, if One table fails, roll back all the transaction, how to do this?
Below tb001,tb002, and tb003 is recordset, But doing like this throw me error.
On Error GoTo HandleErr:
tb001!Field1 = txtProdName
tb002!Field1 = INITIAL
tb003!Field1 = "abc"
So, what is the correct and easy way to do that?
P/S: I am open to all kind of solution, including change to ADO, or using the feature in Microsoft Access 2003, or anything else. Thanks.