passthrough to fire a SP without waiting for results 2

[scotttom]

Hi,

I need to send a query to a stored procedure where I don't want to wait for the results.

This SP can take up to 2 minutes to run and I don't want the users to have to wait before moving on in the code.

I have returns records set to no but I can't figure out how to just move along without waiting.

How do i do that?

Thanks in advance for any help.

Scott

 

[PHV]

In your ADO help file have a look at adAsyncExecute

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LonnieJohnson]

Thanks PHV I kinda needed that for some jobs I have that run on a scheduler to scrub data periodically on my SQL Server.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[scotttom]

Thanks PHV,

I think that would have done the trick, but I ended using a SQL job with a process flag.

Good lessons learned traveling down that road, but I appreciate your reply.

Scott