none
Is there any way to stop a long-running query? RRS feed

  • Question

  • I'm not seeing any way to other than going to Task Manager and terminating MSACCESS.EXE
    Tuesday, May 10, 2016 6:40 PM

Answers

  • If the query was launched from the Access UI, then hitting the ESC key should terminate.

    The status bar should show this while running the query:

    If the query is quite short in executing time, then ESC may well not stop the query.

    However, if the progress bar as per above is moving, then hitting ESC key (or holding it down for a bit) should terminate the query. I not tested above when the back end is SQL server, but for a Access database, ESC should terminate a long running query.

    Albert D. Kallal (Access MVP)

    Edmonton, Alberta Canada

    Tuesday, May 10, 2016 7:08 PM
  • Hi ,

    You can use CTRL + BREAK or ESC Key but you need to be careful when stopping a query that is something other than just a simple SELECT. If it is an update/insert/delete statement, you may leave your tables in an undesirable
    state.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, May 11, 2016 5:15 AM
    Moderator

All replies

  • If the query was launched from the Access UI, then hitting the ESC key should terminate.

    The status bar should show this while running the query:

    If the query is quite short in executing time, then ESC may well not stop the query.

    However, if the progress bar as per above is moving, then hitting ESC key (or holding it down for a bit) should terminate the query. I not tested above when the back end is SQL server, but for a Access database, ESC should terminate a long running query.

    Albert D. Kallal (Access MVP)

    Edmonton, Alberta Canada

    Tuesday, May 10, 2016 7:08 PM
  • Hi ,

    You can use CTRL + BREAK or ESC Key but you need to be careful when stopping a query that is something other than just a simple SELECT. If it is an update/insert/delete statement, you may leave your tables in an undesirable
    state.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, May 11, 2016 5:15 AM
    Moderator