Timer event versus action query

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?
 
A

Allen Browne

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.
 

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

Cancel timer event if criteria not met 1
Remotely disconnect users 4
Unhandled runtime errors kill form timer events 12
Understanding Timer Pause Code 6
Append Query to Mainform and Subform 0
Use more than one timer event on a form? 1
Change event not happening 3
Better then Timer Event? 3

Top