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.
 

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

open SQL store procedure from adp 0
SQL server backend 2
How to execute a parameterized Sql store procedure within Excel? 1
How to execute SQL stored procedure from Access 8
Pass-Through performance issue 4
Migration to 2007 error 2
Running a Store procedure from DAO 2
create a form using a store procedure from sql 6

Top