View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kjamison@travelers.com is offline
external usenet poster
 
Posts: 7
Default Problems with the Close statement not releasing the database fastenough.

On Sep 2, 2:49*am, wrote:
Hi
You didn't try it inside the loop?
Talking of vista, I have some code which uses DoEvents to animate a
graph smoothly. In Vista I have to put 3 consecutive DoEvents lines in
to make it go at all - like "Do the bl**y event will you!"
Paul

On Sep 1, 6:34*pm, wrote:



I tried that and it didn't help. *It seems to be a VISTA issue.


I loaded 2007 on another desktop I have that still has XP, and ran it
and it worked fine, so must be the VISTA.


I put the DoEvents Statement right before the Loop - seemed like that
should do it, but it still bombs. *When I step through the code
(meaning there is time for the database updates to actually take) - it
works fine - so I somehow need to slow the application down - gotta
love VISTA- Hide quoted text -


- Show quoted text -


It was within the Loop. I may play a bit with what you did - adding a
few DoEvents statements - you did make me laugh though.... THANKS.