Append Query Chain?

[dgriffis1231]

So I am pulling data from a SQL data base into access and appending it to certain tables. To do this I have 15ish append queries. Is there a way to have them run in a certain order with one command?

 

[pbaldy]

In VBA code or a macro, just execute them in sequence, like:

CurrentDb.Execute "Query1"
CurrentDb.Execute "Query2"
CurrentDb.Execute "Query3"

 

[dgriffis1231]

Is it possible to tell the system to compact
And repair at certain points in the process?

 

[pbaldy]

I'm not sure how practical that would be. I don't think it would work on the db the code is in. It might work on a separate back end, but you'd have to know nobody else was connected to it. I assume you can't just link to the SQL Server tables?