access application hangs when in focus

[Guest]

hello all,

I would greatly appreciate anyone's help in solving the
following bug.

When I run my delphi application that calls A97 on a XPpro
machine, the sql querry takes 5 to 10 times longer to
complete when the application is in focus.

if I focus to another window, or even press the "Start"
button from the task bar, the querry runs ok.

the querries use Max() or Groupby.


BTW - the application runs ok on a Win98 machine. I also
tried opening the tables and keeping the link open before
running the sql, .. still on improvement.

it's actually quite amazing to see that when ever I move
to another window, the application instantly completes.
It's like it hangs or something.

 

[Arvin Meyer]

It seems like an OS issue with Delphi, since it runs OK except on XP. I
don't know why, but you might try running the Object Pascal equivalent of
the Visual Basic DoEvents command (assuming there is one), which
relinquishes control of the program to the OS to do its tasks, then takes it
back when they are finished.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access