What is this error????

[jedel]

High All,

I HATE these errors. Not having the knowledge needed to identify what this is, I'm at a loss as to how to fix it.

I have two pages, one that allows me to edit using a web editor. This transfers the data to and update page where I can submit the data into an access database.

I use a session variable (helpID) to find the correct record to update for the second page (ie find records in helpTBL where Primary key = session key)

The Session variable is written in the first page

<%Session("helpID") = (Pages.Fields.Item("fileID").Value) %>

I know this works because I have the session written on both pages so that I know I have the right records to update.

The problem is when I submit the second page i get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record.

/help/admin/helpUD.asp, line 38

Line 38 is just an execute line and it executes the update paramaters. here they are:

Set MM_editCmd = Server.CreateObject ("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_helpfiles_STRING
    MM_editCmd.CommandText = "UPDATE filesTBL SET Title = ?, Category = ?, Code = ? WHERE fileID = ?" 
    MM_editCmd.Prepared = true
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 255, Request.Form("txtTitle")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 50, Request.Form("txtCat")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 203, 1, 1073741823, Request.Form("txtCode")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 5, 1, -1, MM_IIF(Request.Form("MM_recordId"), Request.Form("MM_recordId"), null)) ' adDouble
    MM_editCmd.Execute

So now I have no idea what the problem is. I thought the database was a problem, but all of the fields are in the table. The DSN is working fine.

And now, I'm hoping that someone here might be able to help me.

-------------------------------------------------------------
"The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."