DAO:
Set DB = OpenDatabase(DatabaseName, False, False, ";Pwd=密码")ADO:
cnn.ConnectionString = "................." & ";Jet OLEDB:Database Password=密码"
Set DB = OpenDatabase(DatabaseName, False, False, ";Pwd=密码")ADO:
cnn.ConnectionString = "................." & ";Jet OLEDB:Database Password=密码"
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("Data Source").value = App.Path & "\data.mdb"
.Properties("Persist Security Info").value = True '这个
.Properties("Jet OLEDB:Database Password").value = "pass"
.CommandTimeout = 30
End With