Hi,

Is it possible to run two or three concurrent stored procedures with multiple connection strings? If so, how. I already have my access front end calling the stored procedures in sequence but I want them to run concurrently.

Any and all help would be greatly appreciated.

No, due to Access being a single threaded program, I don't believe you will never achieve this unless there is something in SQL Server that can do that. You would need to kick off the item to do it in SQL (perhaps a DTS package set up to run them concurrently).

nh,

You can specify when you execute a SQL Server stored procedure that
you want it to run asynchronously. Access will not wait for the call to
return.

Also, I guess that you could open up three different connections to the
database and "sequentially" fire off 3 stored procedures asynchronously
and they would all execute concurrently.

But why would you want to do that?

Wayne