databasedev.co.uk - database solutions and downloads for microsoft access

User Accounts

Now that you've created new Microsoft Access Group Accounts, it's time to create new user accounts in Microsoft Access.

When you create user accounts for an application, those accounts are stored in the workgroup that the users join when they use the application. Therefore, before you create the user accounts, you should make sure that you are in the correct workgroup information file.

You can add a user to a group account or remove a user from a group account by making selections in the Users tab of the Users And Group Accounts dialog box. Similarly, you can delete a user account or a group account from a workgroup by making selections in the Users tab or the Groups tab of the Users And Group Accounts dialog box. You cannot delete the group accounts Admins or Users.

Task A-4: Creating User Accounts in Microsoft Access

Objective: To create the administrator's user account as well as four other user accounts, and to assign each user to a group. This information relates to the sample Microsoft Access database download

Before you begin: The User and Group Accounts dialog box is open, and the Order Entry and Sales Managers group accounts are created - please complete the previous tutorial Setting up Microsoft Access Group Accounts before starting.

1. Select the Users tab.
2. Display the Name drop-down list. There's only one user listed, Admin. You're going to create five more users to add to this list.
3. In the Groups section, look at the Available Groups list. Four groups are listed, including the two that you created. You can assign users to these groups.
   
   
4. In the User section, click New to open the New User/Group dialog box.
5. Create a user account for yourself, as follows:
   
   Name: (Your Name)
   Personal ID: mypid
   
   Click OK.
   
   
6. From the User Name drop-down list, select your name.
7. From the Available Group list, verify that Admins is selected. Click Add to create a security administrator account with you as administrator. You are a member of the Admins group. As such you inherit Administer rights to import files, create new users, and assign permissions.
   
   
8. Create the following new user accounts and assign each user to the indicated group accounts:
   
   

   User Name	Personal ID	Group Membership
   Olivia E	oliviapid	Order Entry; Users
   Oscar D	oscarpid	Order Entry; Users
   Scott S	scottpid	Sales Managers; Users
   Susan M	susanpid	Sales Managers; Users

9. Display and scroll through the Name drop-down list. Now there are six user accounts, including Admin, yourself, and the additional four that you have created.
10. In the User And Group Accounts dialog box, click OK to accept your account additions.

Next we'll look at Changing a Security Account Password.

Go to page:

1. Steps to Securing an Access Database by Using User-level Security
2. Setting Logon Procedures
3. Group Accounts
4. User Accounts
5. Changing a Password
6. The Security Wizard
7. Permissions
8. Testing Security
9. Documenting Database Security
10. Previewing Permissions
11. Securing a Database with a Database Password
12. Distributing the Secured Application