我做了个高校学生消费情况的网络问卷调查,现在问题卡在一下代码执行出错,写入不了数据到ACCESS数据库。
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("data123.mdb")
name=request.form("name")
major=request.form("major")
number=request.form("number")
exec="insert into guest(name,major,number) values('"+name+"','"+major+"','"+number+"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
错误提示如下: