Can I slow Access down? (1 Viewer)

[Chris RR]

I never thought that I'd be asking this...

I'm using Access 2000 to run an automated, scheduled daily process that emails a report. The VBA code does some file transfers, runs a half a dozen queries, then archives and sends out a very complicated report.

The problem is that the email is now sometimes incomplete. This used to run fine in Access 95, when I had a slower PC, and runs just fine if I step through it slowly. So I think that Access is just getting ahead of itself.

Is there an easy way to slow things down to let Access catch up with itself? Would dbengine.idle help?

 

[Former]

Chris - what you want to do is use the command DoEvents, at critical points in your code, i.e. after the call for each query, report etc.
Hope this helps

 

[Chris RR]

It went into production today & looks good so far...