Using a stored proc in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top