Multi-tasking in MS Access

Question

Hi - I'm using MS Access 2007.  Is there an easy way to run multiple queries concurrently?  I'd like to multi-task, but I have 1 query that typically runs for an hour.  In the meantime, I have smaller ad hoc queries that I'd like to run while I'm waiting for the big one to finish.  Is there an easy way to run queries in parallel?  Thanks!

Answer 1

Scott,

Actually, I found out quite the contrary...  I was running a set of queries just like that and had to put a DoEvents between each run because they were constantly running on top of each other and causing an issue with my file.  I know it;s not *suppose* to happen but it does and I have no explanation for why.

---

--

Gina Whipp

2010 Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.

Gina,

Let me restate, the USER can't do anything else while a query is running. Yes, its certainly possible for the queries to run on top of each other when executed in batch. But I think what the OP wanted was do other things in Access while a query was running in the background and and I don't believe that is possible.

---

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2010 Blog: http://scottgem.spaces.live.com/blog Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

Answer 2

Scott,

Actually, I found out quite the contrary...  I was running a set of queries just like that and had to put a DoEvents between each run because they were constantly running on top of each other and causing an issue with my file.  I know it;s not *suppose* to happen but it does and I have no explanation for why.

---

--

Gina Whipp

2010 Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.

Answer 3

Gina's solution will run all your queries in a batch. But while query is running you cannot do anything else in Access.

---

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2010 Blog: http://scottgem.spaces.live.com/blog Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

Answer 4

I'd be more interested in understanding why you have a query that takes an hour to run.  How many records are you working with?

Answer 5

Something like...

DoCmd.OpenQuery "NameOfYourQuery"

DoCmd.OpenQuery "NameOfYourQuery"

DoCmd.OpenQuery "NameOfYourQuery"

Keep going till all your queries are there and place that in the On_Click event of a button on a form.  You probably want to make sure the queries are not try to *play* in the same table.

---

--

Gina Whipp

2010 Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.