Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Multiple Queries
0 views
Skip to first unread message
MarkS
Nov 7, 2007, 6:29:00 PM11/7/07
to
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
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
Nov 8, 2007, 1:24:08 AM11/8/07
to
On Wed, 7 Nov 2007 15:29:00 -0800, MarkS <Ma...@discussions.microsoft.com>
wrote:
wrote:
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]
0 new messages