problem in update statement
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...
DB= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=path/DB.mdb; Persist Security Info=False"
Set conn = Server.CreateObject("ADODB.Connection")
id = request.querystring("update")
password = Request.Form("password")
ssql = "UPDATE table SET pass='" & password & "' WHERE id=" & id
thanks for the help
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.