你试试~ 以前我用的代码,应该可以的~~
Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\mysany\qq1.mdb;Persist Security Info=False"
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select * from 表1"
Set DataGrid1.DataSource = Adodc1
Me.Refresh
End Sub