[AccessD] [ACCESS-L] Varying results in an A2007/A2010 ADP stored procedure

I created a new mdb and it returns correctly, as expected via a pass
through query.

I'm going to try a box with an Access version <2007 to test the ADP.



On Wed, Dec 21, 2011 at 11:44 AM, Duane Hookom <duanehookom at hotmail.com>wrote:

> How does it look if you try this in a Pass-Through query?
>
> Duane Hookom
> MS Access MVP
>
>
> > From: davidmcafee at GMAIL.COM
> >
> > A coworker wrote a new stored procedure that works just fine when ran
> from
> > SSMS.
> >
> >
> > If either of these are ran from SSMS:
> >
> > EXEC stpR6Payouts '1/1/2011','11/30/2011',''
> >
> >
> > EXEC stpR6Payouts '1/1/2011','11/30/2011',NULL
> >
> > The data is returned as expected.
> >
> >
> > If, the sproc is ran from VBA, or directly through the immediate window,
> we
> > get different results.
> >
> > The sproc run from Access will return a few rows short, and data is being
> > calculated incorrectly on the rows that are returned.
> >
> > Hit F5 in Access, and a different row count (and data on the returned
> rows)
> > will be different.
> >
> > I've always assumed SQL was doing all the work and returning a resultset
> to
> > Access, but it doesn't appear this is actually what happens.
> >
> > Does anyone have any ideas?
>
> --------------------------------------------------------------------------
> The ACCESS-L list is hosted on a Windows(R) 2003 Server running L-Soft
> international's LISTSERV(R) software.  For subscription/signoff info
> and archives, see http://peach.ease.lsoft.com/archives/access-l.html .
>                             COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=ACCESS-L
>