ADP results help needed

[Joe]

I created an ADP that runs SQL stored Procedures.
I have four in one form, all except one return all the
rows from thier respective SP's.

When I run my SP in SQL I get 2361 rows, when I run it in
ADP it only returns 80. If I adjust the row count after it
runs and set the rows to 0 it gives me all.
Is there a way to default this?

Thanks,
Joe

 

[Brian M. Sockey]

Hi Joe,

I wrote a couple of articles that should shed some light on what you're
experiencing and how to work around it:

ACC2002: Action Query Does Not Affect All Valid Records in an Access Project
http://support.microsoft.com/default.aspx?scid=kb;en-us;287429

ACC2002: How Access Projects (ADPs) Use the DefaultMaxRecords Setting and
the T-SQL Set Rowcount Statement
http://support.microsoft.com/default.aspx?scid=kb;en-us;283200

Let me know if you have any questions,

Brian M. Sockey
www.farsightsolutions.com