创建带密码的空数据库

文章作者 100test 发表时间 2008:01:04 12:43:52
来源 100Test.Com百考试题网

Function CreatePassWordDB(strPathName As String, strPsd As String) As Boolean
On 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 "备份失败！" &. vbCrLf &. vbCrLf &. Err.Description, vbExclamation
Exit Function
End Function