Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Joe]

This is the error that I get from an update statement that when I run the
statement in access the statement works fine as so with IIS 4, but when I
run the statement on IIS 5 I get the error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query

here is the code:
upd = "update inventory set itemno = '" & request.form("itemno") & "', photo
= '" & request.form("photo") & _
"', description = '" & request.form("description") & "', weight = '" &
request.form("weight") & _
"', warehouseloc = '" & request.form("location") & "' where ID = " & request.form("ID")



set rs = conn.execute(upd)
help!!! thanks in advance Joe

[George]

"Joe" <jfrey@pvcomm.com> wrote:
>
>This is the error that I get from an update statement that when I run the
>statement in access the statement works fine as so with IIS 4, but when
I
>run the statement on IIS 5 I get the error:
>
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
>query
>
>here is the code:
>upd = "update inventory set itemno = '" & request.form("itemno") & "', photo
>= '" & request.form("photo") & _
> "', description = '" & request.form("description") & "', weight = '" &
>request.form("weight") & _
> "', warehouseloc = '" & request.form("location") & "' where ID = " & request.form("ID")
>
>
>
>set rs = conn.execute(upd)
>help!!! thanks in advance Joe

Do You Use This Syntax -->

rst.Open "SELECT * FROM INVENTORY WHERE ID="+request.form("ID"), Conn,3,3

rst.Update "The Field" , <<new value>>
rst.Update "The Field" , <<new value>>
rst.Update "The Field" , <<new value>>
rst.Save

rst.close