Search results

Thank you The_Doc_Man for the detailed response! And arnelgp for the distinction. So, in general, DoEvents will allow pending processes by the OS to be executed, while DBEngine.Idle will allow pending processes by MS Access to be executed. Would it ever be appropriate to use both together...

In the past I have used DoEvents between queries in VBA to ensure each query was accomplished before the next. But I have read that the DBEngine.Idle would be better suited in a multi-user environment. (Such as a Frontend on each user's computer linked to a Backend database on the server) SO...