asp+access插入记录后，提示错误

Question

<!--#include file="conn.asp"-->
<!--#include file="md5.asp"-->

<%
username= trim(request("username"))
realname = server.htmlencode(trim(request("realname")))
password = request("password")
password1 = request("password1")
ask = trim(request("ask"))
answer = trim(request("answer"))
email = server.htmlencode(trim(request("email")))
if username = "" then
conn.close
set conn = nothing
response.write "<script>alert('请输入用户名');history.go(-1);</script>"
response.end
end if
if len(username) > 20then
conn.close
set conn = nothing
response.write "<script>alert('用户名不得超过10个汉字');history.go(-1);</script>"
response.end
end if
set rs = server.createobject("adodb.recordset")
sql = "select count(userid) from users where username='"&username&"'"
rs.open sql,conn,1,1
if rs(0) > 0 then
rs.close
set rs = nothing
conn.close
set conn = nothing
response.write "<script>alert('该登录名已经有人使用了');history.go(-1);</script>"
response.end
end if
rs.close
if realname = "" then
conn.close
set conn = nothing
response.write "<script>alert('请输入真实姓名');history.go(-1);</script>"
response.end
end if
if password = "" then
conn.close
set conn = nothing
response.write "<script>alert('请输入登录密码');history.go(-1);</script>"
response.end
end if
sql = "insert into users ("username","realname","password" ,"ask" ,"answer","email") values('"&username&"', '"&realname&"', '"&password&"', '"&ask&"', '"&answer&"','"&email&"')"
conn.execute(sql)
conn.close
set conn = nothing
response.write "<script language=javascript> alert('注册成功，点击确定立即登录！');location.replace('index.asp');</script>"
response.end
%>

提交之后出现错误，
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/chengping/RegisterOk.asp, line 49, column 27
sql = "insert into users ("username","realname","password" ,"ask" ,"answer","email") values('"&username&"', '"&realname&"', '"&password&"', '"&ask&"', '"&answer&"','"&email&"')"

是什么问题，帮我看看吧~谢谢

Answer 1

sql = "insert into users (username,realname,password,ask,answer,email) values('"&username&"', '"&realname&"', '"&password&"', '"&ask&"', '"&answer&"','"&email&"')"

Answer 2

用Insert Into时有几点要注意
1.字段是否与保留字、关键字重复，不确定的就把字段名用[]号括起来。
2.字段的数据类型，字符一定要用‘’括起来，等等。
3.不要插入备注类型。

Answer 3

sql = "insert into users (username,realname,password ,ask ,answer,email) values('"&username&"', '"&realname&"', '"&password&"', '"&ask&"', '"&answer&"','"&email&"')"

字段名是不加引号的