Hi All,
am trying to update access database with this sql statemnt,

set ors = oConn.Execute( " update items set date_db='" & request.form("t1") & "', item='" & request.form("t2") & "', item2='" & request("t3") & "', item3='" & request("t4") & "', dollar_price='" & request.form("t5") & "', cent_price='" & request.form("t6") & "', um='" & request.form("t7") & "' WHERE items.item_ID="&request.form("t8")&" " )

and alwayes get this error message:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'items.item_ID=2></td> </tr> <tr> <td height='.
/asp/update.asp, line 52

the item_id in the database is outonumber field am not sure if this what causing the problem,
any help will be appriciated .