MS Access Timer Event for long process?
Posted on 2012-08-15
I am developing an app that needs to regulary read emails and load the data into an MS Access database. It is preferred that the emails get loaded as quickly as possible so ideally I would like to run the loop as often as possible. Unfortunately with just 9 emails in the system the process takes as long as about 80 seconds. This gives rise to the following questions:
1. If I set the timer to run every 90 seconds and the process takes longer than 90 seconds to run, does this mess up the timer?
2. Does a MS Access form timer run in the same thread as the rest of the processing, in which case the process will force the user to stop and wait for an 80 second process to occur every 90 seconds, clearly unacceptable.
Any suggestions/options, please????