求助:向ACESS数据库中添加记录总是出现错误
向ACESS数据库中添加记录,代码如下,总是出现错误提示 :Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/reg2.asp, 第 12 行 (兰字部分)
不知道是什么原因,请高手指教!多谢!
<!--#include file="conn.asp"-->
<%
name=request.form("name")
pwd=request.form("pwd")
wenti=request.form("wenti")
daan=request.form("daan")
sex=request.form("sex")
tel=request.form("tel")
email=request.form("email")
message=request.form("message")
exec="insert into mingxi(name,pwd,wenti,daan,sex,tel,email,message)values('"+name+"','"+pwd+"','"+wenti+"','"+daan+"','"+sex+"',"+tel+",'"+email+"','"+message+"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>