Article ID: 103992
Article Last Modified on 1/26/2005
APPLIES TO
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q103992
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
If you add a security command to a custom menu with a DoMenuItem action, the security command will be unavailable.
CAUSE
You can only perform DoMenuItem actions with commands available from the current context. If you have a form open, you can only perform menu items available to a form. Since security items are available only from the Database window, they will not work when invoked from a form.
RESOLUTION
You can add the security command Change Password to a custom menu using the following sample macro:
Macro Name Action Defined Below
----------------------------------------------
Change Password Echo 1
SelectObject 2
DoMenuItem 3
DoMenuItem 4
SelectObject 5
Change Password Actions
---------------------------------------------------------
1. Echo
Echo On: No
2. SelectObject
Object Type: Form
Object Name: <name of the form that the menu is on>
In Database window: Yes
3. DoMenuItem
Menu Bar: Database
Menu Name: Security
Command: Change Password
4. DoMenuItem
Menu Bar: Database
Menu Name: Window
Command: Hide
5. SelectObject
Object Type: Form
Object Name: <name of the form that the menu is on>
In Database window: No
NOTE: Actions 1 and 5 are used if you need to have the Database window hidden while using the retail version of Microsoft Access. The Echo action in step 1 ensures that the Database window is not visible when it is activated in step 2. Step 4 hides the Database window again. If you are using the Microsoft Access Distribution Kit (ADK), steps 1 and 5 can be omitted since the Database window is always hidden.
The only side effect to this workaround is that when the Change Password dialog box appears, you will see the Database window menu items in the background. However, you will not be able to choose them.
STATUS
This behavior no longer occurs in Microsoft Access version 7.0.
MORE INFORMATION
Steps to Reproduce Behavior
Create the following macro and save it as Security Menu:
Action Defined Below ------------------------- AddMenu 1 Security Menu Actions --------------------------------------------- 1. AddMenu Menu Name: Security Menu Menu Macro Name: Security Menu Password Status Bar Text: Change PasswordCreate the following macro and save it as Security Menu Password:
Macro Name Action Defined Below ------------------------------------------ Change Password DoMenuItem 1 Security Menu Password Actions ------------------------------ 1. DoMenuItem Menu Bar: Database Menu Name: Security Command: Change Password- Create a form and set the OnMenu property to Security Menu.
- View the form in Form view and note that Change Password is unavailable on the Security menu.
Keywords: kbfix kbprb kbusage KB103992
