executing a querydef

  • Thread starter Thread starter mchd
  • Start date Start date
M

mchd

hi all,

I wonder why there is big difference in time execution between executing a
querydef bye code withe an intruction of type
currentdb().execute "MyQueryDef"
and executing the same querydef directly from the database window. In this
last case it ends quicly while it takes much more time the coding way

Thanks for any help
 
Hi,


Maybe the user interface executes the process asynchronously, behind the
scene, on a lower priority thread of execution? It is like when you open a
large table, you immediately see the first records, but it takes some time
to get them all. The interface comes to you immediately, but continue the
job behind the scene.

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top