Linking a SQL Stored Procedure to Access 2002

J

John Flaherty

Hi,

can anyone tell me how to link a SQL stored procedure to
Access 2002. Linking tables & views is easy but I can't
seem to find a way to link stored procedures.

I'm using Microsoft SQL Enterprise Manager - version 8
with Access 2002


Thanks a ton

John
 
D

Douglas J. Steele

Create a pass-through query that calls the stored procedure, and use that
query.
 

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
Stored Procedure in SQL Server vs MSDE 2005 SQL Server 2
What does linking a Access table to an SQL table mean? 2
Super Basic SQL LINKING question... 2
Problem linking to SQL tables in Access 4
I'm not able to select some specific tables from sql server intoAccess- santosh 2
Access 2002 .adp subform linking using stored procedures 1

Top