Microsoft KB Archive/295203

= ACC2002: A Parameterized Stored Procedure Returns No Output Columns If You First Open It in Design View =

Article ID: 295203

Article Last Modified on 10/20/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295203



This article applies only to a Microsoft Access project (.adp).

Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
A stored procedure that includes parameters does not display output columns in Datasheet view or a field list in PivotTable or PivotChart view if you first open the stored procedure in Design view.



CAUSE
This issue has been known to occur on computers that are running Microsoft Data Access Components (MDAC) version 2.5.



RESOLUTION
To resolve this issue, obtain MDAC version 2.6. For more information about MDAC 2.6, visit the following Microsoft Web site:

http://msdn.microsoft.com/dataaccess



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Behavior
 On a computer that has MDAC 2.5 installed, open the sample project NorthwindCS.adp. Open the Sales by Year stored procedure in Design view. On the View menu, click Datasheet View.  Enter the following for the parameter prompts:   Beginning_Date: 01/01/98 Ending_Date: 12/31/98 Note that no output columns are displayed; however, the number of records that are returned is displayed. </li></ol>

Additional query words: pra

Keywords: kbbug kbnofix KB295203

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.