Access freezes until a ctrl/alt/delete

[Jo Taylor via AccessMonster.com]

I have an intensive application that uses Access as a front end, hitting
SQL tables, using VB code running a mix of pass thru queries, Access
queries and stored procedures. Throughout processing, we log records to a
table to chart where we are at in the processing. In a couple places, the
application seems to hang up or run way too long. i.e. runs 5 minutes one
night, 30 minutes the next, and will occastionally just timeout. Runs
correctly about 95% of the time. When the user goes to task manager, (and
does nothing else), the application starts running. The prone code is
within a dowhile loop, does a mix of things, repaints the form, the form
has a progress bar etc.

I'm wondering what is happening when we go to task manager, so I can take
corrective action. My initial thoughts are that repaint is causing a
problem.

 

[JohnFol]

it might be worth sticking a DoEvents in to release control temporarily back
to the operating system. Also if you are using DAO within the code for the
non-passthrough, have a look at

DBEngine.Idle [dbRefreshCache]

Remarks

The Idle method allows the Microsoft Jet database engine to perform
background tasks that may not be up-to-date because of intense data
processing.