I need to perform 3 different queries against a table in an Access database using ADO from VB6.

I want all 3 queries to be successful. If one of them fail, I want them all to fail.

I guess this could be done via a transaction but I'm not sure how to do it.

I would appreciate any example code you can provide that initiates a transaction via ADO.

Thanks in advance..

Dan