update on ms access

[blackrider]

Hello!

I have a small problem.

I have this data base (DB) connection for microsoft access


set conn=Server.CreateObject("ADODB.Connection")
conn.Open "arcaNoe"
set rs = Server.CreateObject("ADODB.recordset")


and i want to do one update on the table, with the following command:

...

"update from comp set del='1' where numcliente="&tempId(i)
...


' arcaNoe is the name of my DB
' comp is the name of my table
' del it´s a string
' tempId(i) it´s an "int" number


When i put this code on my page, the output is that error:


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement


The DB have full control permissions

Thanks for your help...

[Roelf]

i believe the update command does not need the from keyword
"update comp set del='1' where numcliente=" & tempId(i)