Function OpenProtectedDB(strDBPath As String, _
strPwd As String)
Dim cnnDB As ADODB.Connection Set cnnDB = New ADODB.Connection ' Open database for shared (by default), read/write access, and
' specify database password.
With cnnDB
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("Jet OLEDB:Database Password") = strPwd
.Mode = adModeReadWrite
.Open strDBPath
End With
' Code to work with database goes here.
cnnDB.Close
Set cnnDB = Nothing
End Function
strPwd As String)
Dim cnnDB As ADODB.Connection Set cnnDB = New ADODB.Connection ' Open database for shared (by default), read/write access, and
' specify database password.
With cnnDB
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("Jet OLEDB:Database Password") = strPwd
.Mode = adModeReadWrite
.Open strDBPath
End With
' Code to work with database goes here.
cnnDB.Close
Set cnnDB = Nothing
End Function
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货