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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
SQL server backend 2
SQL Stored Procedure 1
Oracle stored procedure 5
How to invoke a sql stored procedure from ACCESS 6
Access pass-through query to Oracle 10g stored procedure - results 1
stored procedure query 4

Back
Top