Function CheckUserPasswordInGroup(UserName As String, _
oldPassword As String, newPassword As String) As Boolean
On Error GoTo ChkErr
Dim wk As DAO.Workspace, Ur As DAO.User, i As Integer, Found As Boolean
CheckUserPasswordInGroup = False
Found = False
' 必須用擁有管理權限的帳號開啟工作區
Set wk = DBEngine.CreateWorkspace("", "Admin", "")
' 遍歷用戶集合查找目標用戶
For i = 0 To wk.Users.Count - 1
If wk.Users(i).Name = UserName Then
Set Ur = wk.Users(i)
Found = True
Ur.NewPassword oldPassword, newPassword ' 修改密碼
Exit For
End If
Next i
If Not Found Then
MsgBox "'" & UserName & "' 不是有效的用戶名!", vbExclamation, "艾賽思應用網"
Exit Function
End If
CheckUserPasswordInGroup = True
Exit Function
ChkErr:
MsgBox "'" & UserName & "' 用戶密碼修改失敗!", vbExclamation, "艾賽思應用網"
CheckUserPasswordInGroup = False
End Function
注意:若原密碼為空,傳入 "" 而非 Null,兩者在 VBA 中不同。