Microsoft KB Archive/216425

= PRB: Error '80040e10' Too Few Parameters. Expected 1: Error Using ADO from ASP Against Access Database =

Article ID: 216425

Article Last Modified on 6/12/2001

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition
 * Microsoft ActiveX Data Objects 2.0
 * Microsoft ActiveX Data Objects 2.1 Service Pack 2
 * Microsoft ActiveX Data Objects 2.5
 * Microsoft ActiveX Data Objects 2.6

-



This article was previously published under Q216425



SYMPTOMS
If you use ActiveX Data Objects (ADO) to manipulate data in an Access database from within an Active Server Pages (ASP), and you refer to a column in a table that does not exist, you may see the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.

Customer/ASP Page8.asp, line 12



CAUSE
This error occurs only with Microsoft Access when one of the column names specified in a select statement does not exist in the table being queried.



RESOLUTION
Remove any invalid column names from the select statement.

Additional query words: error 80040e10

Keywords: kbdatabase kbprb KB216425

-

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

© Microsoft Corporation. All rights reserved.