Dim cnn1 As ADODB.Connection Dim rscourse As ADODB.Recordset Set cnn1 = New ADODB.Connection cnn1.Provider = "microsoft.jet.oledb.4.0" con1.CursorLocation = adUseClient '这一句容易忽略 cnn1.Open "D:\Documents and Settings\luyu\My Documents\vb\毕业设计\通讯录97.mdb" Set rscourse = New ADODB.Recordset rscourse.Open "名片表", cnn1, adOpenDynamic, adLockOptimistic, adCmdTable Set DataGrid1.DataSource = rscourse
rscourse.Open "名片表", cnn1, adOpenDynamic, adLockOptimistic
Dim rscourse As ADODB.Recordset
Set cnn1 = New ADODB.Connection
cnn1.Provider = "microsoft.jet.oledb.4.0"
con1.CursorLocation = adUseClient '这一句容易忽略
cnn1.Open "D:\Documents and Settings\luyu\My Documents\vb\毕业设计\通讯录97.mdb"
Set rscourse = New ADODB.Recordset
rscourse.Open "名片表", cnn1, adOpenDynamic, adLockOptimistic, adCmdTable
Set DataGrid1.DataSource = rscourse