有关ADO的问题，急急急！！！

[normandj]

我是这样打开一个记录集的：
Set dbConnection = New ADODB.Connection
dbConnection.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" + MDIForm1.varDataBaseName + ";Data Source=" + MDIForm1.varServerName
dbConnection.Open
Set dbRecordset = New ADODB.Recordset
dbRecordset.ActiveConnection = dbConnection
dbRecordset.Source = "select * from project"
dbRecordset.CursorLocation = adUseClient
dbRecordset.CursorType = adOpenKeyset
dbRecordset.LockType = adLockOptimistic
dbRecordset.Open
但当我：
dbrecordset.delete
它就会出现错误：
-2147217887 多步 OLE DB 操作产生错误。请检查每个 OLE DB 状态值。没有工作被完成。

或者

3219 操作在该内容中不被允许。

请问我哪里出错?

[shuchang0626]

Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=数据库的绝对路径;Persist Security Info=False"
cnn.CursorLocation=adUseClient
cnn.Open
rst.Open "select * from 表", cnn, adOpenStatic, adLockPessimistic
；
这样连是对的

[normandj]

啊，对不起，我发现不是delete的错误，而是 addnew 后 update 就出现这样的错误.