运行时提示‘对象打开时,不允许操作’
运行时,第一次按COMMAND1,DATAGRID出来列表,可第二次按COMMAND1,出来‘对象打开时,不允许操作’的错误提示。
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Command1_Click()
rs.CursorLocation = adUseClient
rs.Open "select * from stu where name like '%" & Text1.Text & "%' ", conn, adOpenKeyset, adLockOptimistic
DataGrid1.ClearFields
Set DataGrid1.DataSource = rs
DataGrid1.Refresh
End Sub
Private Sub Form_Load()
Dim connstr As String
connstr = "Provider = 'Microsoft.Jet.OLEDB.4.0';Data Source=F:\练习\test.mdb"
conn.Open connstr
End Sub