萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> Access 教學 >> Access 基礎教學

VBA 修改工作組用戶密碼函數:支援空密碼與錯誤處理

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 中不同。

copyright © 萬盛學電腦網 all rights reserved