Execute Store Procedure

  • Thread starter Thread starter SF
  • Start date Start date
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
 
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.
 
Back
Top