<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
password1=request.Form("pass1")
password2=request.Form("pass2")
password3=request.Form("pass3")
if password2<>password3 or password2="" then
%>
<script language=vbscript>
alert("两次输入的新密码不一致，请重新输入！")
history.back()
</script>
<%
end if
set conn=server.CreateObject("adodb.connection")
conn.connectionstring="provider=microsoft.jet.oledb.4.0;data source="&server.MapPath("357159842.mdb")
conn.open
sql="select * from [user] where name='"&session("id")&"' and password='"&password1&"'"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,2
if rs.eof then
%>
<script language=vbscript>
alert("你输入的密码不正确，请重新输入！")
history.back()
</script>
<%
else
set rsl=server.CreateObject("adodb.recordset")
sqll="update [user] set password='"& password2 &"' where name='"&session("id")&"'"
rsl.open sqll,conn,1,2
response.write"恭喜您，密码修改成功！"
rs.close
set rs=nothing
rsl.close
set rsl=nothing
conn.close
set conn=nothing
end if
%>
</body>
</html>
运行了出现如下的错误：
Microsoft JET Database Engine 错误 '80040e14'
UPDATE 语句的语法错误。
我感觉没错，请各位高手帮一下忙，帮我找一下错误！
