我用rs.open "Select * from table1",conn,3,3打开一个记录集，后来进行一个操作rs.Delete，可是老是报“对象不支持该操作”，什么原因？

could not reproduce your problem, here is what I did:Dim rs As ADODB.Recordset
Dim sConn As String
sConn = "Provider=SQLOLEDB;Server=localhost;UID=sa;PWD=;Database=tempdb"Set rs = New ADODB.Recordset
rs.Open "select * from table1", sConn, 3, 3rs.MoveFirst
While Not rs.EOF
   MsgBox rs("col1")
    rs.Delete
    rs.MoveNext
Wend
rs.UpdateBatchrs.Close
Set rs = Nothing