Access: sets permissions and accounts for users and groups.

First, move the mouse over the tool button on the main menu, and then click the left mouse button to bring up a sub menu, move the mouse over the security option on the menu, A menu is displayed on the right of this option. Move the mouse over the user and group permissions on the menu and click the left mouse button. A dialog box is displayed on the screen.

First, move the mouse over the tool button on the main menu, and then click the left mouse button to bring up a sub menu, move the mouse over the security option on the menu, A menu is displayed on the right of this option. Move the mouse over the user and group permissions on the menu and click the left mouse button. A dialog box is displayed on the screen.

First, move the mouse over the tool button on the main menu, and then click the left mouse button to bring up a sub menu, move the mouse over the security option on the menu, A menu is displayed on the right of this option. Move the mouse over "user and group permissions" and click the left mouse button. A dialog box is displayed on the screen,

In this dialog box, we can change the access permissions of different users to the database or an object. If we want the user Li Ming to open only the form for running the database, instead of opening other tables or queries, we only need to select "Li Ming" in the user name ",, select "form" in the object type drop-down box, select a form, and then move the mouse to the permission box to select the "open/Run" items available for Li Ming, click "OK", so that Li Ming can only see the form in use, but cannot modify other data content. You cannot view or query the table.

We only talked about how to set permissions for users or groups, but how to grant certain permissions to all the users required? Of course, each user or group must have one account, in this way, management can be performed to assign permissions.

To implement this function, just as before, click the mouse in the menu on the right of the security options, but click "set user and group account" this time ", the "user and group account" dialog box is displayed.

We also need to manage users or groups in this dialog box. The dialog box contains three tabs. The first one is used to manage the user name in an existing group. On this tab, you can click "new" to add new users to the "user group" or "other groups", or click "delete" to delete the users in the group. Click "Clear password" to cancel the password of the original user.

In the list of the two groups below, all groups are on the left, and the group of the user in the text box above is on the right. Click the select button in the middle to control the user's group. Different groups can have different permissions. After such management, users in the same group will have the same permissions.

The Group tab is used to manage groups.

You can click "new" to add a group or click "delete" to delete a group. Each group can be obtained by clicking the combo box.

"Change login password" option

After a user logs in to Access using his or her original password, he or she can change his or her Access password for security reasons. After setting these settings, click "OK.