Access database security issues

Question 1. What is a Microsoft Access workgroup and how to create a workgroup information file? 2. How to open "Working Group Manager"? 3. How can I allow others to view or execute queries, but cannot change the data or query design? 4. How to Prevent replication, set database passwords, or change startup options? 5. How to define user-level security? Q: What is Microsoft?

Question 1. What is a Microsoft access workgroup and how to create a workgroup information file? 2. How to open "Working Group Manager"? 3. How can I allow others to view or execute queries, but cannot change the data or query design? 4. How to Prevent replication, set database passwords, or change startup options? 5. How to define user-level security? Q: What is Microsoft?

Problem

1. What is a Microsoft access workgroup and how to create a workgroup information file?
2. How to open "Working Group Manager"?
3. How can I allow others to view or execute queries, but cannot change the data or query design?
4. How to Prevent replication, set database passwords, or change startup options?
5. How to define user-level security?

Q: What is a Microsoft Access workgroup and how to create a workgroup information file?

A: The Microsoft Access workgroup is a group of users who share data in a multi-user environment. If user-level security is defined, the members of the workgroup are recorded in the user account and group account, and these accounts are saved in the Microsoft Access workgroup information file. The user's password is also saved in the workgroup information file. You can specify permissions on databases and their objects for these security accounts. Permissions are stored in the security database.
In Microsoft Access 97, user settings are stored in the Hkey_Current_UserSoftwareMicrosoftOffice8.0AccessSettings keyword of the Windows registry. In earlier versions of Microsoft Access, user option settings defined in the "options" dialog box are recorded in the workgroup information file.

The default workgroup is defined by the workgroup information file automatically created by the installer in the folder where Microsoft Access is installed. You can use "Workgroup Manager" to recreate a workgroup.

Q: How can I open "Working Group Manager"?

A: If you are using Windows 95 or Windows NT Workstation 4.0, you can use "my computer" or "Windows" Resource Manager "to open the Microsoft Access installation folder (the default folder is PRogram FilesMicrosoft OfficeOffice), and double-click Wrkgadm.exe.

Q: How can I allow others to view or execute queries, but cannot change the data or query design?

A: In the Security Workgroup, you can specify the permission for others to view and query the returned data. For Operation queries, you can also allow them to perform queries, even if they are restricted from viewing the queried base table or basic query.
1. Open the query in the design view.
2. In the query design view, click anywhere outside the design grid and field list to select a query.
3. Click "properties" on the toolbar to display the queried Attribute Table.
4. Set the "execution permission" attribute to "Owner's ".

When this attribute is set, the following situations should occur:

. All users have the query owner's permission to view or execute the query.
. Only the query owner can save the modified query.
. Only the query owner can change the query ownership.

You can also set the default permissions for all new queries. Click "options" on the "Tools" menu, click the "Table/query" tab, and then click the "execution permission" option you want to use.

Q: How can I prevent replication, set database passwords, or change startup options?

A: If the shared database does not define user-level security, the above changes cannot be prevented. After user-level security is defined, only user accounts or group accounts with administrator permissions can copy databases, Set passwords, and change startup attributes.

Q: How to define user-level security?

A:
1. Join a Security Working Group or create a new working group information file.
To fully ensure database security, do not use the default workgroup defined in the workgroup information file created when Microsoft Access is installed. Make sure that the information file of the working group to which the definition belongs is created using the unique working group ID (WID). Otherwise, create a new working group.

2. Activate the "Logon" dialog box.
Operation Method: Start Microsoft Access, open the database, click the "user and group account" command in the "Tools" menu "security" submenu, and click the "user" tab, make sure that the pre-defined "Administrator" User Account in the "name" box is highlighted. Click the "Change logon password" tab, click the "new password" box, and type a new password. Do not enter anything in the "old password" box, enter the password again in the "verify" box to confirm, and then click "OK. Exit ACCESS and restart ACCESS. The "Logon" dialog box appears.

3. Create an administrator account.

Operation Method:

1) Open the Working Group Manager and press "Join ..." Click, select the Security workgroup Information File Created in step 1st, exit the manager, and start Microsoft Access.
If you want to ensure that the database is completely secure, do not use the default workgroup defined in the workgroup information file created when Microsoft Access is installed, make sure that the workgroup information file defining the Working Groups used is created with a unique working group ID (WID). Otherwise, a new working group information file should be created.

2) Select the "user and group account" command in the "Tools" menu "security" sub-menu, and click the "new" button on the "user" tab, in the "new user/group" dialog box, type the Administrator account name and personal ID (PID), and then click "OK" to create an account.
Warning remember the correct account name and PID, including uppercase and lowercase letters, and place them in a safe place. If you want to recreate an account, you must provide its name and PID. If you forget or lose your account name and PID, you cannot recover it.

3) in the "available groups" box, click "Administrator group" and then click "add. Microsoft Access adds a new Administrator account to the Administrator group and displays "Administrator group" in the "affiliated" box ".

4) Click "OK" to create an administrator account.

4. log out of Microsoft Access and log on as the new Administrator.

5. Delete the Administrator account in the Administrator group.

Operation Method: Select the "user and group account" command in the "Tools" menu "security" sub-menu, and enter the user to be migrated in the "name" box on the "user" tab. In the "affiliated" box, select the group to be "Administrator group" and click "delete.

6. Open the database to which you want to set security.

7. Click the "user-level security wizard" command in the "Tools" menu "security" submenu.

8. Complete the steps as instructed in the Wizard dialog box.

The "user-level security wizard" will create a new database and export copies of all objects in the original database to the new database, then, cancel all permissions of the user group on the new database object, set security for the selected object type in the first dialog box of the wizard, and then encrypt the new database. No changes were made to the original database. The relationship between tables and all chain tables will be rebuilt in the new database.

Currently, only members of the Working Group Administrator group added to Step 1 can access the objects with security settings in the new database. The "user" group does not have permissions on these objects. To restrict access to these objects by users and/or groups, you must set permissions for these objects.