How to break a selection query if possible

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

 

[Graham R Seach]

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

Thanks.

Frank M.

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

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.