I have an application that calls several MS SQL stored procuedre using ADO. These stored procedure can take 15 to 20 minutes to run. When some users run this they are unable to do anything else on their PC's. While other users have no problems.

Is there any way to change my VB code so that the program has control while the stored procedure is executing and the program goes checks every so often to see if the stored procedure has completed.