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
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top