good day,

i am having a problem where everytime i submitted the form, it will prompt this error :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/kiosk/discount.asp, line 115


and line 115 error is

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute <---this is line 115
MM_editCmd.ActiveConnection.Close

i'm using dreamweaver (aspvb script page) and access..and have a little knowledge on sql,asp or whatsoever..please help me..my dateline is in 1 month from now...please please please!!

thank you very much!

MM_editCmd.CommandType = adCmdText

What is mm_editquery ?

i'm not sure what it is because i'm using dreamweaver mx..every script is ready added on..that is why im having the problem to manipulate the asp script..

i changed it but the same error occured.. can u give me any alternative way to connect my access and dreamweaver?

From my other post to you, you can add response.write in your asp page (not executing the sql) and display the mm_editquery.

You need to add the following code

MM_editCmd.CommandType = adCmdText

before the code of the execution:

MM_editCmd.Execute

Note that you need to include the file adovbs or use

MM_editCmd.CommandType = &H0001