Using a stored proc in Access?

G

Guest

I've written some clever (IMHO) SQL in a stored proc that returns a rowset
that is basically a modification of the rows in the underlying table. Now I'd
like to be able to do SELECTs against it, but I don't see how.

The sp does not appear in the list of "tables" when I attempt to link
(although I seem to remember this happening before), nor can you make a query
or view based on it.

Any pointers?
 
D

Dirk Goldgar

Maury Markowitz said:
I've written some clever (IMHO) SQL in a stored proc that returns a
rowset that is basically a modification of the rows in the underlying
table. Now I'd like to be able to do SELECTs against it, but I don't
see how.

The sp does not appear in the list of "tables" when I attempt to link
(although I seem to remember this happening before), nor can you make
a query or view based on it.

Any pointers?
Click to expand...

Create a stored pass-through query (in the front-end) that executes the
SP. Then select from the pass-through 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

Execute SQL Stored Proc from Access 1
getting return value from stored proc 4
Referncing stored proc from a form 2
getting the oracle stored proc value in .net 1
Select multiple table in 1 stored proc 3
Multi select stored proc and strongly typed data sets 1
Running a Stored Proc 1
Error in row -2147467259 calling sql stored proc from excel 2003 3

Top