MS Access queries transaction

[sumon2]

how to write multiple queries and make it as a transaction in side MS access database
Does any one know?

 

[Francescina]

Yes, as far as action queries are concerned, but you need to give us more details about your project. Otherwise you can not expect a detailed answer.

 

[sumon2]

Thank you Francescina.
Explanation:
table A,table B,table C.
First table A needs to be updated,then table B and then table C in sequence.
If any thing goes wrong at the stage of updating table B or C the whole updation process should rollback.
There by creating a transaction.
I know query properties in MS Access could be changed to transaction:yes.
But i wish to have the transaction to take place in said order and in DB and not in ASP-JScript/VBScript.
Is it possible?

 

[Francescina]

As far as I know Your transaction will only work with VBA, not via the properties of the query in the database window.
Is your MDB file located on a web server? In this case you need to use ASP/ADO features.