Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\MyCodes.mdb;" & _
"Persist Security Info=False;" & _
"Jet OLEDB:Database Password=你的密码"
Set rst = New ADODB.Recordset