Execute Store Procedure

S

SF

Hi,

I jave just migrate to SQL Back end. My front end connect tp sever thru
ODBC. Everything seems to work quite except that executing Store procedure
from Access mdb. During migration, several action queries have been
converted to Store Procedure. How to execute them.

Thank

SF
 
O

Ofer

One option will be to create a pass through query that linked to your SQL
Server, in it type

Exec SPName

This query behave like you are using the SQL Query Analyser in the SQL Server.
 
Top