怎么变成这样呢???我是这样插入的:
if rs1.recordcount=1 then
my_conn.execute("insert into Members(M_Name) values('"&rs1("username")&"')")
my_conn.execute("insert into Members(M_Password) values('"&rs1("cardno")&"')")
set rs=server.createobject("adodb.recordset")
sql="select * from film where (id is null)"
rs.open sql,conn,1,3
rs.addnew
rs("typeid")=Request.Form("typeid")
rs("filmlevel")=Request.Form("softlevel")
rs("runsystem")=Request.Form("runsystem")
rs("title")=title
rs("content")=content
rs("dog")=dog
rs("images")=images
rs("best")=best
rs("dateandtime")=now()
rs("grade")=request.form("grade")
rs.update
filmid=rs("id")
rs.close
set rs=connsql.execute("select user from usertable where user='...'")
if not rs.eof then
set rsp=conn.execute("select password form pwdtable where user='"&rs("user")
&"'")
if not rsp.eof then
connacc.execute("insert usertable(user) values('"&rs("user")"&') '插名
connacc.execute("insert ...") '插密码
end if
end if
'connsql:sql连接字符串;connacc:access连接字符串。
大体思路如此,请测试