MSACCESS SECURITY GROUP ACCOUNT
Create a security group account
As part of securing a database, you can create group accounts in your Microsoft access workgroup that you use to assign a common set of permissions to multiple users.
To complete this procedure, you must be logged on as a member of the Admins group. Start Microsoft Access by using the workgroup in which you want to use the account.
Important : The accounts you create for users must be stored in the workgroup information file that those users will use. If you are using a different workgroup to create the database, change your workgroup before creating the accounts. You can change workgroups by using the Workgroup administrator.
- Open a database.
- On the Tools menu, point to Security, and then click User and Group Accounts.
- On the Groups tab, click New.
- In the New User/Group dialog box, type the name of the new account and a personal ID (PID).
Group names can range from 1 to 20 characters, and can include alphabetic characters, accented characters, numbers, spaces and symbols, with the following exceptions:
- The characters ‘ \ [ ] " | <> + = ; , . ? *
- Leading spaces
- Control characters (ASCII 10 through ASCII 31)
Caution: Be sure to write down the exact account name and PID, including whether letters are uppercase or lowercase and keep them in a secure place. If you have to re-create an account that has been deleted or created in a different workgroup, you must supply the same name and PID entries. If you forget or lose these entries, you can’t recover them.
- Click OK to create the new group account.
Note: A user account name cannot be same as an existing group account name.
To create more Group Accounts repeat steps 3 to 5 above.
Click Next to see how to add users to security groups.