[求助]用ASP 向 MS Access 写的数据写入出现问题

[shks]

我看到一个网页,有如下代码,但是我写成ASP IE 说有语法错误,不知道该如何解决,请高手帮下忙

<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("guestbook.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
rs.close
set rs=nothing
conn.close
set conn=nothing
response.write "记录添加成功!"
%>

[haver.G]

可能是你接收的几个值里面含有"'"的原因.试下替换成全角的.
另可以用Recordset写.

<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("guestbook.mdb")
name=request.form("name")
tel=request.form("tel")
message=request.form("message")
Set rs = Server.CreateObject("Adodb.recordset")
exec = "select name,tel,message from guestbook where name is unll"
Rs.open exec,conn,1,3
'exec = "insert into guestbook(name,tel,message) values('"+name+"',"+tel+",'"+message+"')"
rs.addnew
rs("name")=name
rs("tel")=tel
rs("message")=message
rs.update
'conn.execute exec
rs.close
set rs=nothing
conn.close
set conn=nothing
response.write "记录添加成功!"
%>

[shks]

还是有问题,我再看看,修改一下

[seahyesung]

LZ，很可能是变量的定义，name是关键字，应该不能定义为变量，你最好改一下，试试··