在access下可以正常运行，转成SQL数据库后，这里就会暴错？？？？
ADODB.Recordset 错误 '800a0e78 '

对象关闭时，不允许操作。

/admin/admin.asp，行 51


代码部份：

if request( "action ")= "del " and request( "id ") <> " " then

set rs=Server.CreateObject( "ADODB.Recordset ")
sql= "delete from admin where id= "&abs(request( "id "))
rs.open sql,conn,3,3
rs.update ----------------行 51
set rs=Server.CreateObject( "ADODB.Recordset ")
sql= "delete from article where userid= "&abs(request( "id "))
rs.open sql,conn,3,3
rs.update
rs.close
set rs=nothing


end if


[解决办法]
这还不够完整？
if request( "action ")= "del " and request( "id ") <> " " then
conn.execute( "delete from admin where id= "&abs(request( "id "))& ";delete from article where userid= "&abs(request( "id "))& "; ")
end if
[解决办法]
呵呵~``删除，更新，插入，根本用不着Recordset，除非有些字段要判断~