Timer event versus action query

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

What happens when an action query is running (for half an hour or more...),
and a timer event fires, which event executes an "application.quit" action?
 
Try it, Jim.

The answer could be different in different versions of Access. JET is not
multi-threaded, so the query runs in its own thread. But recent versions of
Access are multi-threaded (if I understand correctly), so if the attempt to
perform the quit while the uncompleted query is in progress could occur. I
think you'll have to test this on the version of Access you are interested
in.

The O/S could also make a difference in some cases. Vista has much lower CPU
utilization for these long tasks than XP:
http://allenbrowne.com/VistaCPULoad.html

You may care to post the results you get as a reply to your thread.
 
Back
Top