Dim Cnn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Set Cnn = New ADODB.Connection
Cnn.CursorLocation = adUseClient
Cnn.Open "Provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\data.mdb;Persist Security Info=False"
'实例化recordset对象
Set Rs = New ADODB.Recordset
Set sel_RS = New ADODB.Recordset
'rs.Open "data", cnn, adOpenDynamic, adLockOptimistic
Rs.Open "select * from data ", Cnn, adOpenDynamic, adLockOptimistic
'用datagrid浏览出数据库的记录
Set DataGrid1.DataSource = Rs