Tuesday, July 29, 2014

How To Creating User and Group Accounts in Access 2003

If many users work on the same database or a database contains confidential information, you might want to restrict access to specific information for certain users. You can do this by setting up individual accounts for each user. If users share a common characteristic or job description (such as those in charge of entering personnel data), you may want to place them in a common group. Members of the same group would share the same rights and privileges within Access. Before you set up accounts, you are, by default, the Admin user in the Admin group. This gives you complete control over all databases.

Create a User Account

graphics/1_icon.jpg
Click the Tools menu, point to Security, and then click User And Group Accounts.
graphics/2_icon.jpg
Click the Users tab.
graphics/3_icon.jpg
Click New.
graphics/4_icon.jpg
Type a name for the new user.
graphics/5_icon.jpg
Type a personal identifier.
graphics/6_icon.jpg
Click OK.
graphics/7_icon.jpg
Click OK.
graphics/12inf03.jpg

Create a Group Account

graphics/1_icon.jpg
Click the Tools menu, point to Security, and then click User And Group Accounts.
graphics/2_icon.jpg
Click the Groups tab.
graphics/3_icon.jpg
Click New.
graphics/4_icon.jpg
Type a name for the new group.
graphics/5_icon.jpg
Type a personal identifier.
graphics/6_icon.jpg
Click OK.
graphics/7_icon.jpg
Click OK.
graphics/12inf04.jpg