请问怎么样实现把要删除的记录格外的保存起来????能不能给小弟点代码......

sql="select aaa,bbb from t1 where id="&id
rs.open sql,conn,1,1
sql="insert into t2 (delid,aaa,bbb) values("&id&",'"&rs("aaa")&"','"&rs("bbb")&"')"
conn.execute sql
rs.close()
sql="delete from t2 where id="&id
conn.execute sql

sql="select aaa,bbb from t1 where id="&id
rs.open sql,conn,1,1
if not rs.eof then
sql="insert into t2 (delid,aaa,bbb) values("&id&",'"&rs("aaa")&"','"&rs("bbb")&"')"
conn.execute sql
end if
rs.close()
sql="delete from t2 where id="&id
conn.execute sql


这样呢?

注意安全 呵呵