Microsoft][ODBC Microsoft Access 驱动程序] 语法错误 (操作符丢失) 在查询表达式 'num =' 中。
问题：Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access 驱动程序] 语法错误 (操作符丢失) 在查询表达式 'num =' 中。
/houtai/DELshenqing.asp，行 10
其中，DELshengqing.asp如下：
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
dim num1
set conn=server.createobject("adodb.connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=C:\inetpub\wwwroot\grad\shujuku.mdb"
set rs=server.createobject("adodb.recordset")
num1 = trim(Request.Form("checkuser"))
exec="delete * from sbsq where num ="&num1&""
rs.open exec,conn,1,3
response.Redirect"shenqing.asp"
%>
shengqing.asp如下：
<%@ Language=VBscript%>
<%if not session("checked")="yes" then
response.Redirect "../login.asp"
else
%>
<%
dim exec,conn,rs
exec="select * from sbsq "
set conn=server.createobject("adodb.connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=C:\inetpub\wwwroot\grad\shujuku.mdb"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-color: #D9D9D9;
}
.STYLE1 {
font-size: 36px;
color: #546CB4;
}
.STYLE2 {
font-size: 18px;
color: #A73EC1;
}
.STYLE3 {color: #FF0000}
-->
</style></head>
<body><form name="form1" method="post" action="DELshenqing.asp">
<div align="center">
<p><span class="STYLE1">管理员界面</span><span class="STYLE2">在线申请</span></p>
<table width="725" height="47" border="1">
<tr>
<td width="108"><div align="center">请选择</div></td>
<td width="108"><div align="center"> 编号</div></td>
<td width="108"><div align="center">用户名</div></td>
<td width="135"><div align="center">地址</div></td>
<td width="135"><div align="center">类型</div></td>
<td width="91"><div align="center">原因</div></td>
</tr><%do while not rs.eof%>
<tr>
<td>
<label>
<div align="center">
<input type="checkbox" name="checkuser" value="<%=trim(rs("num"))%>">
</div>
</label>
</td>
<td><div align="center"><%=rs("num")%></div></td>
<td><div align="center"><%=rs("name")%></a></div></td>
<td><div align="center"><%=rs("address")%></div></td>
<td><div align="center"><%=rs("leixing")%></div></td>
<td><div align="center"><%=rs("yuanyin")%></div></td>
</tr><%
rs.movenext
loop
%>
</table>
<span class="STYLE3">请选择要删除的文件单击确定</span>
<label>
<input type="submit" name="Submit" value="确定">
</label>
</div></form><%rs.close
set rs=nothing
conn.close
set conn=nothing %>
</body>
</html>
<%end if%>
在线等，急求，谢谢大家。
