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


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
  • ActiveX Data Objects (ADO) 2.0
  • ActiveX Data Objects (ADO) 2.1 SP2
  • ActiveX Data Objects (ADO) 2.5
  • ActiveX Data Objects (ADO) 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.
Modification Type:MajorLast Reviewed:6/12/2001
Keywords:kbDatabase kbDSupport kbprb KB216425
©2002 Microsoft Corporation. All rights reserved.