Access front-end - linking to sql stored procedure?

[jpicks]

Hi all.

I have an Access 2000 database that is using sql server 2000 as a back-end. I am able to link to tables and views that are in sql server (using a file dsn connection), but have been unable to determine how to link to stored procedures. Does anyone out there know of a way to do this?

Thanks in advance.

 

[Rolliee]

Not sure this is possible. Or even that you want to. Write your own procedures or import them from what others have written in ACCESS.


rollie@bwsys.net

 

[jpicks]

All of the data is already in sql (all tables, views, and stored procedures). I want to use Access as a way for our users to view this data and allow them to build their own reports off of it.

The sql database has been around for a while and already has a number of stored procedures that are being used by an asp application. I'm hoping that I can simply reuse these stored procedures, instead of writing new views in sql (or queries in access).

 

[mikeyb540]

There is a way... try Pass-Through query. In the SQL view type EXEC YOURSPNAME. Then you have to enter the ODBC connection string in the properties.