刚学一个例子,运行提示
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。



程序如下:
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb")
name=request.form("name")
tel=request.form("tel")
message=request.form("message")
exec="insert into guestbook(name,tel,message)values('"+name+"',"+tel+",'"+message+"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
是怎么回事呢?

<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb")
name=request.form("name")
tel=request.form("tel")
message=request.form("message")
exec="insert into guestbook(name,tel,message) values('"&name&"',"&tel&",'"&message&"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>

谢谢!明天试试!

还是同样的错误呢!
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/example5.asp, 第 8 行(也就是"conn.execute exec"这行)
是不能写入吗?

原来搞错了,行了
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("db1.mdb")
xh=request.form("xh")
qzsj=request.form("qzsj")
xm=request.form("xm")
xb=request.form("xb")
csny=request.form("csny")
whcd=request.form("whcd")
zyjn=request.form("zyjn")
qzyx=request.form("qzyx")
lxdh=request.form("lxdh")
tzmsdw=request.form("tzmsdw")
exec="insert into seeker(xh,qzsj,xm,xb,csny,whcd,zyjn,qzyx,lxdh,tzmsdw)values("&xh&",'"&qzsj&"','"&xm&"','"&xb&"',"&csny&",'"&whcd&"','"&zyjn&"','"&qzyx&"',"&lxdh&",'"&tzmsdw&"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>

怎样就行了呢？我的也是这样，把tel和message去掉就行，加上就还是"INSERT INTO 语句的语法错误".

检查字段的数据类型与要插入的数据类型是否匹配。