Hi,

Is there a way to cancel a query? What I mean is that when I open a recordset, I would like to have the option to cancel the action if it takes too long.

I see that there is a cancel method for a recordset but I can't seem to execute while the recorset is being opened.

I know that you can use command timeout, but that doesn't give you the option to wait for as long as it takes or stop the query whenever you please. It only waits for a determined time.

Many thanks,

RF