Hi.

Some time ago I wrote a specialized Excel files merging tool using
Access. Input .xls files can be extremely large, so calculation
required for merging may last for a long. I have realized a group of
classes to organize tracking of merging process and showing the
progress of done work using a progress bar. Everything seemed to be ok,
but now two main problems are arising:

1) When I activate the main window of another application in front of
my form and after that minimize it, my form can't repaint its contents
and shows white background or some images remained from that other
application. Repainting of the form is impossible because the only
thread is busy with calculations. There is a worse situation: after
minimizing all application windows using "show desktop" button, it's
impossible to show my form by clicking the taskbar icon because the
application can't respond to user actions until the merging process is
done; and now it's impossible to see the progress of the merging
process.

2) If the user starts the merging process, the only way to abort it is
killing the Access process, but I prohibit them to do that, so they
have no choice but waiting till the end of calculations.

So are there any alternatives to multithreading for solving these
problems in Access?

Thanks in advance

Martin

martin-g wrote:
A well placed DoEvents in the code might ease this. OTOH if the
bog-down happens because JET is beating up the disk on some forever-long
query, it might not.

--
Smartin