Hi,

   I'm getting a following error.

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)

 during research I found out that this problem is related to missing 
column name or mis-spelled column name. I've checked over n over and found 
no discrepencies or spelling errors. Could there be anything else 
generating this that I'm over looking? 

Any help in this matter will be greatly appreciated.

Thanks in Advance.

Hi,

   I'm getting a following error.

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)

 during research I found out that this problem is related to missing 
column name or mis-spelled column name. I've checked over n over and found 
no discrepencies or spelling errors. Could there be anything else 
generating this that I'm over looking? 

Any help in this matter will be greatly appreciated.

Thanks in Advance.

test

The usual problem is actually not enough parameters:
http://www.adopenstatic.com/faq/80040e10.asp

Suppose you have:

<%
strSQL = "UPDATE Users SET UserID = " & intUserID
objConn.Execute (strSQL)
%>

you will get an error if intUserID has no value

I suggest you Response.Write() your SQL statement to the screen so that you
can see what you are sending to the database.

Cheers
Ken


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "rafehd Darr" <Rafehd@y...>
Subject: [access_asp] [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.


: Hi,
:
:    I'm getting a following error.
:
: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
: Number: -2147217904 (0x80040E10)
:
:  during research I found out that this problem is related to missing
: column name or mis-spelled column name. I've checked over n over and found
: no discrepencies or spelling errors. Could there be anything else
: generating this that I'm over looking?
:
: Any help in this matter will be greatly appreciated.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~