Multiple Queries

[Guest]

Hi,
I need to delete all the data in a update table, run several quries to load
the data into the update table and then append the data in the update table
to the final table. I have several queries which do this and one query that
runs then all in the correct sequence. Is there a better way to do this
because if one of the queries fails the update to the final table still
happens but the data is incomplete

Thanks

 

[John W. Vinson]

Hi,
I need to delete all the data in a update table, run several quries to load
the data into the update table and then append the data in the update table
to the final table. I have several queries which do this and one query that
runs then all in the correct sequence. Is there a better way to do this
because if one of the queries fails the update to the final table still
happens but the data is incomplete

Thanks

I'd suggest running all the queries in sequence from VBA code, wrapped in a
Transaction. See the online help for Transactions, it's pretty good - if that
doesn't make it clear post back.

John W. Vinson [MVP]