创建一个带密码的空数据库
创建一个带密码的空数据库
Function CreatePassDB(strPathName As String, strPsd As String) As BooleanOn Error GoTo Exit_ERR
Dim wrkDefault As Workspace
Dim NewDB As Database
CreatePassWordDB = False
Set wrkDefault = DBEngine.Workspaces(0)
If Dir(strPathName) <> "" Then Kill strPathName
Set NewDB = wrkDefault.CreateDatabase(strPathName, dbLangGeneral & ";pwd=" & strPsd & "")
NewDB.Close
Set NewDB = Nothing
CreatePassWordDB = True
Exit Function
Exit_ERR:
MsgBox "备份失败！" & CrLf & vbCrLf & Err.Description, vbExclamation
Exit Function
End Function