>ESC interrupt the query when escape set on. After user response to continue or stop the query messagebox, query is continuing from interrupted point.
I see. I am not sure how to solve this.
On the other hand, somehow I never worried too much about interrupting queries, because I usually manage to optimize them. Perhaps you should try to do the same. That is, if the query takes 5-10 seconds instead of 5-10 minutes, there is really no reason to interrupt in the middle of a query. Few of my queries take longer than that.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)