Running Pass Through Queries by Code

N

Niceaction

Hi,
I am investigating the use of Pass Through Queries to run SQL code on a
Oracle platform.
I have created a Create Table query which uses the Pass Through Query to
populate itself (will get re-created every time I run it).
I am then trying to execute the Create Table Queries in VB from a form using
the 'DoCmd.OpenQuery ' function. When I do this, it waits until the first
table has been created before moving down the code to start the next Create
table. Is there anyway I can set both of these off at the same time, without
the need for one to finish?
Thanks
Jamie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top