关于在ASP中用update

Question

<%
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Demo.mdb"
'更新记录
Dim Sql, Rs
Conn.Execute ("update user set username='happy',age='10' where sex='女'")
Response.Write "OK"
Conn.Close
Set Conn = Nothing
%>
不知道哪里错了。。
<%
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\user.mdb"
Rem 添加/插入记录
Dim Sql, Rs
Conn.Execute("Update Students Set [PassWord]='24362345',RealName='我' Where UserID='201030620002'")
Response.Write "OK"
Conn.Close
Set Conn = Nothing
%>
下面那个能够显示“ok”，而且能改，为什么上面那个稍微改一下就不仅显示错误，也布更新不到？

Answer 1

除了以上可能外，还要检查是否为主键更新冲突。把这句sql放入access中执行查询可以找到失败的原因。

Answer 2

Conn.Execute ("update user set username='happy',age='10' where sex='女'")
试试改下
Conn.Execute ("update user set username='happy' and age='10' where sex='女'")

Answer 3

Conn.Execute ("update [user] set username='happy',age='10' where sex='女'")

Answer 4

显示什么错误，把错误放上来

Answer 5

age字段是int类型还是文本，如果是int类型请改成age=10