Access hangs while processing

  • Thread starter Thread starter thriveni
  • Start date Start date
T

thriveni

I am currently using Access 2000.

Whenever I am running my program that sometimes takes 20 -
30 minutes to finish, and I click on the mouse to do
something else the running program goes into the 'not
responding ' mode. That is till the access process has
finished running I cannot use the machine for anything
else. Is this just an ACCESS feature or can I change some
settings to disable this.

Thanks in advance for any help.
 
I've seen this before, although it says not responding it is doing fine.
This is a resource thing. If you have more RAM or processing power this may
not happen. But either way, you can still do stuff and it will eventually
come out of it. But in general I don't because you run the risk of a
time-out and data corruption. Good luck!
 
A little cryptic, perhaps?! For the OP: your code should execute
DoEvents every few seconds - if your code is looping, which most code
that runs for this long will be doing, you need to put the DoEvents
call somewhere where it will be executed about that often. If your
outer loop is going significantly faster than that, integer divide the
loop counter by something appropriate and execute DoEvents every time
the result changes.

Use:

DoEvents
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top