how do I combine multiple make table queries

[Guest]

I have several Access make table queries that link to an Oracle database, can
they be combined into one query that executes each make table query?

 

[Roger Carlson]

No, you'll have to use a VB module. There are a number of ways you can do
it. I'd suggest this:

Sub RunMakeTableQueries()
dim db as Object
set db = CurrentDb
db.Execute "Query1", dbFailOnError
db.Execute "Query2", dbFailOnError
db.close
End Sub

If you put this subroutine in a general module, you can run it from
anywhere.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[John Vinson]

I have several Access make table queries that link to an Oracle database, can
they be combined into one query that executes each make table query?

Unlike SQL/Server or Oracle, you can't put multiple action queries
into one query. What you can do instead is write a VBA routine which
executes multiple action queries one after the other.

John W. Vinson[MVP]

 

[aaron.kempf]

you should be using Access Data Projects and SQL Server.

MDB is for retards and lepers; spit on anyone that uses it.

-Aaron