Multiple Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top