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

They are all hidden under the queries tab of the database window. From the
moment Access introduced the ADP format, I was instantly and totally hooked.
In fact, I have won a couple of bottles of beer when some snotty DBA said,
"Oh yeah, can you talk to the system tables?" and I whipped up an app on the
spot that not only spoke to the system tables but had combo-boxes too. It's
a lot of fun to do that to people who think Access is a toy.

A.


On 6/18/07, Darren D <darrend at nimble.com.au> wrote:
>
> Hi Arthur et al
>
> I had no Idea what an ADP was - this looks like it could do the trick -
> way cool
>
> I have been to the MS site and had a look at their blurb on this and in
> their
> screen dumps the ADP's display an outlook style tab (tables, Queries,
> reports
> etc) called Store Procedures
>
> http://msdn2.microsoft.com/en-us/library/aa155779(office.10).aspx
>
> But when I create an ADP I do not see this - Though the usual suspects are
> there
> - Tables, Queries, Forms, Reports etc
>
> Any clues on why I don't see Stored Procs?
>
> Many thanks
>
> Have a great day
>
> Darren
> ------------------
>
> -----Original Message-----
> From: Arthur Fuller [mailto:fuller.artful at gmail.com]
> Sent: Tuesday, 19 June 2007 12:22 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.9.0/852 - Release Date: 17/06/2007
> 8:23
> AM
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.9.0/852 - Release Date: 17/06/2007
> 8:23
> AM
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>