Run Multiple Queries Simultaneously

[Shatterday]

Hello,

I currently have a database that creates local tables from ODBC connections to a DB2 database. These queries are run each morning. At present, each of them are run sequentially. As some of them are very large, it may take a significant amount of time before it finishes and runs the next make-table query.

What I would like to do is figure out a way to run them all at the same time. My thoughts were to possibly run each query in a separate instance of Access, preferably without having to create a separate Access database for each query. However, that is an option.



The idea comes from being able to create 2 databases, have them both open, and then run a make table query in both, at the same time.

Has anyone ever tried this before?

[Robeen]

Have you tried 'cloning' your database, putting an AutoExec Macro in each and having it run two different MakeTable queries - and then setting up your Windows Task Scheduler open both databases at the exact same time?
I've never tried this but I'd like to know how it goes if you try it.
I've always tried to schedule my databases to open each morning so as NOT to get in each others' way.