Microsoft KB Archive/100970

From BetaArchive Wiki
Knowledge Base

ADT: How to Give Users the Ability to Change Passwords (2.0)

Article ID: 100970

Article Last Modified on 6/13/2001


  • Microsoft Access Distribution Kit 1.1
  • Microsoft Access Developer's Toolkit 2.0

This article was previously published under Q100970


Advanced: Requires expert coding, interoperability, and multiuser skills.

This article describes how to distribute a secure application with the Microsoft Access Distribution Kit or Microsoft Access Developer's Toolkit and still give your users the ability to change their passwords.


To achieve this functionality, do the following:

  1. Make the Database window active so that you can access the Security menu. (The best method for this is to select an object in the Database window through a macro).
  2. From the Security menu, choose Password. The user then changes the password.
  3. Once the user has closed the Password dialog box, set the focus back to the form that you called the macro or function from.

    Here is a sample macro:

          Macro Name         Actions
          Change Password    SelectObject
          Change Password Actions
              Object Type: Macro
              Object Name: Autoexec
              In Database window: Yes
              Menu Bar: Database
              Menu Name: Security
              Command: Change Password
              Object Type: Form
              Object Name: Form1
              In Database window: No

The Database window appears, as well as the dialog box to change the password. You cannot select anything in the Database window because the Change Password dialog box is modal.

In the Microsoft Access Distribution Kit or Developer's Toolkit, the functionality is identical except that the Database window is not displayed.

Additional query words: container adk adt nxml

Keywords: kbhowto kbusage KB100970