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:

Microsoft Visual InterDev, version 6.0
ActiveX Data Objects (ADO), versions 2.0, 2.1 SP2

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 kbDatabase kbVisID600 kbGrpASP kbGrpMDAC kbDSupport kbRDS210SP2
Version : WINDOWS:2.0,2.1 SP2,6.0
Platform : WINDOWS
Issue type : kbprb