Hi all:

I have a serious problem, i am using asp,and access database
the problem is when i update a row in a table it give me the following error:

Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'cateId='.

cateId is an autonumber field.

the thing that suprise me that the row is updated!! but it give me the above error?

I had write the output to see how it look (response.write(sql))
and it look fine:
here is my asp code for update:

<%
If Request.Form("insert")="update" Then

set con=server.createObject("adodb.connection")
    con.open Application("Product")
    Set con=server.Createobject("adodb.connection")
    Sql="update categories set catename='" & request("catname") & "' where cateId=19"
    con.open Application("product")
    con.execute sql
     con.close
     set con= nothing
     sql=""
End If
Response.Redirect("modifycategory.asp")
%>
  any idea? please I need help as soon as possible.

and what would the catname you're trying to insert be?
First try the SQL without anything dynamic, so you've got:
Sql="update categories set catename='something' where cateID=19"

see if that works then, if it doesn't you know it's not your SQL syntax that's the problem, but something else, like your schema or something.

I am a loud man with a very large hat. This means I am in charge