Private Sub DatabaseWork()
'工程 ---> 引用 ---> Microsoft ActiveX Data Objects 2.x Library
Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
With Conn
If .State = adStateOpen Then .Close
'连接字符串: http://www.connectionstrings.com/
.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=" App.Path _
"\test.mdb;Mode=ReadWrite;Persist Security Info=False"
.Open
End With
If Rs.State = adStateOpen Then Rs.Close
Rs.Open "SELECT * FROM TableName", Conn, adOpenKeyset, adLockReadOnly, adCmdText
'赋记录集进 datagrid 控件,你也可在这里操作记录集。
Set datagrid1.DataSource = Rs
Rs.Close
Set Rs = ntohing
Conn.Close
Set Conn = Nothing
End Sub