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

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
>
>
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.8.16/849 - Release Date: 14/06/2007
> 12:44
> PM
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>