canceling an ado command<BR>I&#039m executing a stored procedure through the ado command object<BR>I would like to know how i would be able to cancel the stored procedure from running once i did command.execute()<BR>how could i cancel an ado command once it started running<BR>I did this <BR>dim adocmd as adodb.command<BR>set adocmd = new adodb.command<BR>adocmd.execute ,, adasyncexecute<BR>and now adocmd.cancel<BR>but when i debug with f8 and i go on the line adocmd.cancel<BR>the cursor doesn&#039t move till the stored procedure end it waits there what am i doing wrong