求高书指点一二,感激不尽!实时错误3706!
Private Sub Command1_Click()Dim Conn As New ADODB.Connection
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB 4.0;Data Source=C:\Users\Administrator\Desktop\毕业设计\用户信息.mdb;Persist Security Info=False"
Conn.Open
Dim ask As Integer
Select Case Index
Case 0
Adodc1.Recordset.AddNew
Case 1
ask = MsgBox("删除否?", vbYesNo)
If ask = 4 Then
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then Adodc1.Recordset.MoveLast
End If
Case 2
Adodc1.Recordset.Update
Case 3
Adodc1.Recordset.CancelUpdate
Case 4
End
End Select
End Sub