Option Explicit'标准声明 Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strCnn As String
Dim strSql As String
'标准调用
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
strCnn = strCnn & App.Path & "\" & MDB名称 & ";" '输入MDB名称
strCnn = strCnn & "Persist Security Info=False"
strSql = "select * from %%%%" '输入SQL语句
Set cnn = New ADODB.Connection
cnn.CursorLocation = adUseClient
cnn.Open strCnn
Set rs = cnn.Execute(strSql)
Set 控件.datasource= rs '输入DG名称
控件.refresh
Dim rs As ADODB.Recordset
Dim strCnn As String
Dim strSql As String
'标准调用
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
strCnn = strCnn & App.Path & "\" & MDB名称 & ";" '输入MDB名称
strCnn = strCnn & "Persist Security Info=False"
strSql = "select * from %%%%" '输入SQL语句
Set cnn = New ADODB.Connection
cnn.CursorLocation = adUseClient
cnn.Open strCnn
Set rs = cnn.Execute(strSql)
Set 控件.datasource= rs '输入DG名称
控件.refresh
但你建完的数据库要进行ODBC连接一下啊