running big queries -- why does the access key symbol turn white?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When running queries with large linked (not local) tables, how do I know the
difference between when the query is running versus not running? The upper
left-hand key icon turns into a white box -- does this mean nothing is
happening?

The task manager says Access is not responding. Why does this keep
happening? No other windows are openend. What can I do?
 
It could be a havy query that take a while, how long you have been waiting to
see if the query finished?

when the query running the task manager will always tell you that Access is
not reponding, so don't pay attention, unless it take it a long time.
Now try running the query adding each table at a time, you might see that
one table can cause it to work slowly.
 
It may just mean that Access is using almost all available CPU processing
power listening and receiving data as well as processing the calculations in
the Query and therefore Access / the OS doesn't have CPU time to repaint the
screen.

Check the network traffic and see if there is still a lot of traffic going
to and from your computer. If there is still traffic, your query is still
being process and when there is spare CPU time (e.g. waiting for data from
the back-end), the screen will be repainted.
 
Back
Top