看 Option Explicit Private conn As ADODB.Connection Private rs As ADODB.RecordsetPrivate Sub Form_Load() Dim apppath As String Dim DbFileName As String Dim ConnectString As String Dim i As Integer Set conn = New ADODB.Connection If Right(App.Path, 1) = "\" Then apppath = App.Path Else apppath = App.Path & "\" End If DbFileName = apppath & "article.mdb" ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DbFileName & ";Persist Security Info=False;" conn.Open ConnectString conn.CursorLocation = adUseClientSet rs = New ADODB.Recordset rs.Open "select id,mc from mz", conn, adOpenDynamic, adLockPessimistic If rs.EOF Then Exit Sub End If Set DataGrid1.DataSource = rsEnd Sub
提示:对象打开时,不允许操作!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Option Explicit
Private conn As ADODB.Connection
Private rs As ADODB.RecordsetPrivate Sub Form_Load()
Dim apppath As String
Dim DbFileName As String
Dim ConnectString As String
Dim i As Integer
Set conn = New ADODB.Connection
If Right(App.Path, 1) = "\" Then
apppath = App.Path
Else
apppath = App.Path & "\"
End If
DbFileName = apppath & "article.mdb"
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DbFileName & ";Persist Security Info=False;"
conn.Open ConnectString
conn.CursorLocation = adUseClientSet rs = New ADODB.Recordset
rs.Open "select id,mc from mz", conn, adOpenDynamic, adLockPessimistic
If rs.EOF Then
Exit Sub
End If
Set DataGrid1.DataSource = rsEnd Sub