Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    24

    Unanswered: controling user and group accounts with vba

    as the subject reads, is it possible to control user and group accounts with vba? if so, does anybody have any links to sample code? thanks

  2. #2
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303
    Its all possible.

    I give the user a form to change their password with. When they enter the old and then the new, and hit the submit, I use commands like these. This should get you started.

    '********************************
    Dim wrkDefault As Workspace
    Dim usrCurrentUser As User

    Set wrkDefault = DBEngine.Workspaces(0)
    Set usrCurrentUser = wrkDefault.Users(CurrentUser())

    usrCurrentUser.NewPassword strOldPassword, strNewPassword

    '********************************

    Maybe that will help you get started in Access's HELP file.
    John
    This is the day the Lord has made, I will rejoice and be glad in it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •