How to force MS Access to WAIT for an append (or any) query to finish, before it moves on to next statement?
Posted on 2013-06-15
Using a SQL-Server back-end, it appears that a long-running union-query is 'kicked off' in a macro (also tried it in a function) and then execution immediately proceeds to the next line of the macro (or function).
Is there a way to make execution WAIT for completion of each query, before continuing on to execute the next?
For years, I've always assumed that a macro with OpenQuery actions just naturally waited until each query is completed before moving on....
Probably something simple. Any thoughts?
Thanks in advance