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

ID: Q216425

The information in this article applies to:

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: 


Keywords          : kbAccess kbADO kbASP kbVisID600 kbGrpASP 
Version           : WINDOWS:6.0
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: March 15, 1999