Running Multiple queries at once

[snypa]

hi Guys,

Is there a way in Access that I can run multiple queries at once, like updating 3 tables from once table using one query??

Cheers for your help

 

[cjard]

It's called a Transaction... You start a transaction, do the updates one after the other and if they all succeeded you commit the transaction and the database behaves as if the updates all occurred simultaneously. If you rollback the transaction the DB undoes all the updates performed though things like sequence numbers cannot be guaranteed to return to the values they were before the transaction started

For more info, see google about transactions, and also the DW2 link in my sig will have some info on it (but I don't remember where, perhaps Saving Related Data)

 

[snypa]

Can I call my stored queries to do the selections or I've to write in all in VBA

 

[cjard]

Yes, no .