在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，除非有些字段要判断~