sql="select top 1 * from article" rs.open sql,conn,1,3 rs.addnew call s**edata() rs("editor")=editor rs.update articleid=rs("articleid")这样就可以获得刚插入值得id。还有一个办法:db.execute("insert into abc values('aaa')") 然后查询(id或时间)的最大值db.execute("select top 1 * from abc order by id desc) 20210311