How to break a selection query if possible

  • Thread starter Thread starter Frank M.
  • Start date Start date
F

Frank M.

Sometimes you may wish to break e.g. a selection query, if after having
started it, you realise that it will take very long to complete. It could be
that it is based on other queries, insufficient indexing, and now you want
to fix it and then restart the query.
Can you break the execution? I thought that perhaps Ctrl + Break would do
the job, but it doesn't work.


Frank M.
 
Thanks.

Frank M.

Graham R Seach said:
Frank,

[ESC]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html


Frank M. said:
Sometimes you may wish to break e.g. a selection query, if after having
started it, you realise that it will take very long to complete. It
Click to expand...
could
be
that it is based on other queries, insufficient indexing, and now you want
to fix it and then restart the query.
Can you break the execution? I thought that perhaps Ctrl + Break would do
the job, but it doesn't work.


Frank M.
Click to expand...
Click to expand...
 
Back
Top