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

The information in this article applies to:

Microsoft Access 2002

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.

MORE INFORMATION

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.

Modification Type:	Major	Last Reviewed:	10/20/2003
Keywords:	kbbug kbnofix KB295203