|
-
Nov 12th, 1999, 03:16 PM
#1
Thread Starter
New Member
Ok, here's my question... I understand that the DoEvents function passes control back to the operating system (although it's not exactly clear what that does). Anyway, I support an application that was written with Access 95 VBA. This app consists of 3 databases which move data from these comma delimited log files into an Access database. Much of this processing happens over a LAN and we've discovered recently that the process slows down SEVERELY at the end. So in going through the code, I found a section that is meant to slow down the program to Access to finish processing before exiting the application. In this procedure a loop of 100 iterations is performed with the only event happening within the loop being a DoEvents command. Does this sound like a good programming practice? When we took it out, for testing purposes, it ran VERY much faster. However, the original programmer clearly commented that they had been having trouble with Access exiting before all processing completed. Is this possible and if so, is there a better way to prevent this than 100 DoEvents commands? PLEASE help me!! Thanks a bunch!
Brian
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|