I don't know if this works in run-time, but I know if there's a long SQL SELECT going on, I can hit ESC and it will pause. I _think_ there's an option to resume, but it's not feasable for me to set up a test right now. I think you need SET ESCAPE ON or some SET along those lines.

Michelle


>Hi,All,
>I've got an interesting problem. I have a form with multiple buttons to start different things. One of these buttons starts a very lengthy process, progress of which I can monitor on a form (using some common ActiveX controls such as ProgressBar). It all works fine, until I've got a request to make a "Pause" button to suspend that process. My first reaction was to create a "PAUSE" button and put "pause"-related code into Click event. It turns out that the system processed that event after the long process finishes.
>My question is - is it any common methods to pause long process invoked from the form?