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.
 
Back
Top