Here’s another question I see pop up from time to time in the Forums.

Since Microsoft did away with User-Level Security (ULS) in Access 2007+, people often wonder how they can manage ULS; add/remove users, change password, …?

The reality of the situation is that although the commands are not front and center, ie they aren’t listed in the Ribbon anywhere, they are still actually there.  Just hidden!

So the question becomes, how can we access them?

Well, there are 2 ways to do this:

• Issue the VBA commands directly
• Customizing the Ribbon

Issue the VBA commands directly

You can access each of the 3 ULS dialogs by using the following 3 VBA commands.

User and Group Account

DoCmd.RunCommand acCmdUserAndGroupAccounts

User and Group Permissions

DoCmd.RunCommand acCmdUserAndGroupPermissions

User-Level Security Wizard

DoCmd.RunCommand acCmdUserLevelSecurityWizard

Customizing the Ribbon

Another options is to simply customize the ribbon.

1. Right-Click on the Ribbon and Select Customize the Ribbon
   
2. In the Choose commands from combo box, select All Commands
3. In the command listbox, scroll down to the User and … commands
4. Use the Add >> button to add the select command(s) to the Tab Group of your choosing or, as in my example, create a new Security Tab Group and add them there.
   
5. You may also like to add the Set Logon Password command to your custom ribbon tab group for the sake of completeness.