Loop Causes Dead Machine

  • Thread starter Thread starter Bill Sturdevant
  • Start date Start date
B

Bill Sturdevant

I have a very complicated loop process running against
thousands of records, and it takes a long time to run.
While it is running, just about everything else on my
machine dies (cannot start Explorer; I can get to
SameTime, but when I minimize that window...; cannot start
Excel).

Is there anything I can do to keep the loop running, but
cede control back to the machine so I (or my user) can do
other things?

Bill
 
Sprinke in a DoEvents or two in your loop somewhere.

You might also want to start thing about how to do the same task with a set
of Sql queries instead of looping if possible.

Ron W
 
Back
Top