[AccessD] A2003: return records from Stored proc in SQL

You can also use a pass-through query in an MDB. I usually
use 2 of them. One that has the exec statement without the
parameters and the second where I replace the SQL with the
SQL from the first and add the parameters needed to
run the stored procedure.

The thing to remember with using a stored procedure
as a recordsource is that the data will be read only.

Robert

At 12:00 PM 6/18/2007, you wrote:
>Date: Mon, 18 Jun 2007 10:22:20 -0400
>From: "Arthur Fuller" <fuller.artful at gmail.com>
>Subject: Re: [AccessD] A2003: return records from Stored proc in SQL
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID:
>         <29f585dd0706180722j4b8570fcx6fa96a4f4716d39d at mail.gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>The simplest way is to supply the name of the sproc as the record source of
>a form (this assumes ADP file format). You'll find near the bottom of the
>data tab of the properties sheet a place to put your parameters.
>
>More complex is to create a recordset and use it to receive the results of
>your sproc. But even then, it wouldn't be "visible", at least to the user,
>until you did something with it.
>
>Dunno if that helped,
>Arthur
>
>
>On 6/18/07, Darren D <darrend at nimble.com.au> wrote:
> >
> > Hi All
> >
> >
> >
> > I have some code that runs a Stored Proc in SQL and it passes the dB name
> > username, pwd etc
> >
> >
> >
> > Cool
> >
> >
> >
> > How do I actually get the results from this Stored Procedure visible in
> > access??
> >
> >
> >
> > Many thanks