White screen during Long running query

  • Thread starter Thread starter Ray C
  • Start date Start date
R

Ray C

I have an Access app that does a lot of number cruching and exports the data
in Excel. However, I notice that when my long running queries are running, I
cannot jump to another application on my PC and jump back to Access (using
the task bar at the bottom of the screen). What I get is a white screen when
I try to get Access to resume its focus. I tried scattering DoEvent commands
in my VBA code that runs the queries but that doesn't help.

Any suggestions? My users are getting annoyed by this. they can't seem to
use their PC for anything when Access is busy running.
 
Try using Alt + Tab to navigate to different programs.

Also consider using Task Manager to see if you are running out of memory.
That could be a cheap fix. I'm assuming that it will show 100% CPU
utilization.

Make sure that the criteria fields in your long running queries are indexed
in the appropriate tables. Ditto for sorted and group by fields.

For a short test, see if turning off your virus checker speeds things up. If
so see if you can exclude it from checking the .md* and .acc* files.
 

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

Similar Threads

Facebook problem on Windows 1
Parameter Query Won't Run 0
Pass Through Query .sql query 3
Query Key 3
How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Update query issue 0
Access #Error & Excel Pivot 0
opaque white rectangle in lower corner of screen above taskbar 1

Back
Top