Unanswered: Connect to Microsoft Access via Stored Procedure
I'm new to SQL server, still in the beginning stage of learning SQL Server. I'm here would like know, besides using the Connectivity from the DTS Designer to connect to different databases, is it possible to connect the database, i.e: Access via stored procedure? and how? Pls advise...
You could use a pass-through query to execute an SQL statement that runs your sproc, but I'm not sure how you would handle any result set that is returned.
Regardless, I am moving this thread to the Access forum, where you may find people who have done this before.
If it's not practically useful, then it's practically useless.