hey guys,
can any1 tell me what is the problem with the following sql? it worked fine when i used the access driver connection string but after changing to the JET SQL driver it stopped working...

Code:
DB= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=path/DB.mdb; Persist Security Info=False"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open DB
id = request.querystring("update")
password = Request.Form("password")
ssql = "UPDATE table SET pass='" & password & "' WHERE id=" & id
conn.execute (ssql)
Code:
Microsoft JET Database Engine error '80040e14' 

Syntax error in UPDATE statement.
thanks for the help