Execute a stored procedure asynchronously

[Kyle Jedrusiak]

Using VBA code is there a way to execute a stored procedure asynchronously?

I don't need a record count, I just need to let the user know that the SP is
still running and possibly allow them to stop it.

Kyle Jedrusiak

 

[Sylvain Lafontaine]

DAO and ADO are both supporting some forms of asynchronous calls; see for
example:
http://www.tek-tips.com/viewthread.cfm?qid=954547&page=1

You should search Google or see the newsgroups m.p.data.ado and
m.p.vb.database.dao

 

[Baz]

Good luck. I have found it impossible to stop an asynchronous SQL batch (at
least in SQL Server 2000). ADO lets you "cancel" it, but SQL Server doesn't
notice this and goes on running it anyway...