BUG: UserConnection Designer and Parameterized Query in Access
Article ID: 185646
Article Last Modified on 1/8/2003
APPLIES TO
- Microsoft Visual Basic 5.0 Enterprise Edition
- Microsoft Visual Basic 6.0 Enterprise Edition
This article was previously published under Q185646
SYMPTOMS
The UserConnection Designer lists parameterized queries in Microsoft Access
as stored procedures; if you define the query object based on a stored
procedure and select one, on the Parameters tab, every single column is
displayed in the query as a parameter along with the actual parameter(s).
Clicking any parameter results in the following error:
"Not a valid name for a parameter."
STATUS
Microsoft has confirmed this to be a bug in the Microsoft products
listed at the beginning of this article. We are researching this
bug and will post new information here in the Microsoft Knowledge
Base as it becomes available.
Additional query words: kbDSupport kbdse kbODBC kbVBp500 kbVBp600 kbVBp
Keywords: kbbug KB185646