不要用ado绑定。
Private strsql As String
Private rs As New ADODB.Recordset
Private dbcn As New ADODB.Connection
Private Const dbcnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
Private rsdata As ADODB.Recordset
Private Sub Form_Load()
Dim ccc As String
Set dbcn = New ADODB.Connection
ccc = App.Path
If Len(ccc) > 3 Then ccc = ccc + "\"
ccc = dbcnStr + ccc + "\Data\*.mdb"
With dbcn
.CommandTimeout = 500
.ConnectionString = ccc
.CursorLocation = adUseClient
.Open
End With
s = "update data set ID " ''''''''''''''''''''''''''''这个data是你要打开的表
dbcn.Execute (s)
Set rsdata= New ADODB.Recordset
strsql = "select * from data"
rsSS.Open strsql, dbcn, adOpenStatic, adLockOptimistic
Set DataGrid1.DataSource = rsdata
Call grddata
End sub
Private Function grddata()
With DataGrid1
.Columns(0).Caption = "ID"
.Columns(1).Caption = "日期"
.Columns(0).Width = 1000
.Columns(1).Width = 1600
End With
End Function