怎么在access数据库中的最后一条记录后面添加记录
帮我看一看下面的代码有错误吗?我想在access数据库的最后一条记录后面添加一条记录.
<%
schoolname=filter_str(request.form("schoolname"))
ucord=filter_str(request.form("ucord"))
address=filter_str(request.form("address"))
tel=filter_str(request.form("tel"))
mainmenu=cint(request.form("mainmenu"))
submenu=cint(request.form("submenu"))
leibie=cint(request.form("leibie"))
set rs=server.createobject("adodb.recordset")
sql="select * from school where(学校名称 is null)"
rs.open sql,conn,1,3
rs.addnew
rs("学校名称")=schoolname
rs("邮政编码")=ucord
rs("学校地址")=address
rs("电话号码")=tel
rs("province_ID")=mainmenu
rs("city_ID")=submenu
rs("leibie_ID")=leibie
rs.update
id=rs("编号")
rs.close
set rs=nothing
conn.close
set conn=nothing
%>