第2个回答 2008-04-02
Private Sub command()
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn = "Provider = MSDASQL.1;" & "Password=***;" & "Persist Security Info=True;" & "User ID=name;" & "Extended Properties=DSN=datafile;"& "DBQ=D:\##\##\##.mdb;" & "DefaultDir=D:\##\##;" & "DriverId=25;" & "FIL=MS Access;" & "MaxBufferSize=2048;" & "PageTimeout=5;" & "PWD=***;" & "UID=name;"
conn.Open
Adodc1.RecordSource = "select * from 数据表名 where 查询条件
Adodc1.Refresh
DataGrid1.ClearFields
DataGrid1.HoldFields
DataGrid1.Refresh
End Sub