Darren D
darrend at nimble.com.au
Mon Jun 18 22:59:53 CDT 2007
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