Access database security system

Access is a computerized database management system that MicroSoft Corporation published in 1994. As a powerful MIS development tool, it has the characteristics of friendly interface, easy to learn, easy to use, simple to develop, flexible interface, and is a typical new generation of data management and information system development tool. Access has a unique advantage over Microsoft's other database products such as FoxPro-providing more powerful data organization, user management, security checks, and more. In a workgroup-level network environment, a multiuser database management system developed using Access has a client server (CIENT/SERVER) structure and corresponding database security mechanisms that are unmatched by traditional xbase database systems. In this paper, the network application and security mechanism of Access database system are discussed in depth.

Establish security systems for access

1. Create an Access workgroup

An Access workgroup is defined as a group of users who share one or more access applications and attach a public to their access copy

SYSTEM. The MDA library. The system administrator (Admin user) of access grants these users the appropriate operational rights to the database system. In this way, different users can access the relevant database resources with different privileges, and in the Xbase system, to implement such a function requires the database developer to implement the control in the programming, And not very perfect.

Access provides a new application microsoftaccessworkgroupadministrator that automatically completes the creation of an Access workgroup. For a workgroup, access system administrators need to use this program to create a new SYSTEM.MDA (or any other file name: *. MDA) library, and point access for each user in the workgroup to this new SYSTEM.MDA. It can be understood that a system database *. The MDA corresponds to a workgroup.

2. Create an Access account in a workgroup

Access accounts include access groups and access users. An access group consists of one or more access user members. During the installation of Access, Access automatically defaults to two user groups (admins and users) and one user (admin), which are not allowed to be deleted by the two user groups and the Admin user. When you enter access by logging on to a user in the Admins user group (such as Admin), you can create a new access group and user and place the new user in the appropriate group.

The Admins group is the Administrator group for Access, which, by default, includes only the admin user, who has the default access to the database and can manage other users and groups of users. The Users group is the default user group for access, and each user, including admin and new users, belongs to the group, which, by default, has full ownership of the database.

3. Set login password for Admin user

The login password of the Admin user is the security portal for the entire database system, why do you say so? Because without the admin login password, access copies of all users log on to the database as the Admin user instead of the user name created by the access administrator, and access starts its security system only if the admin login password is set. This is why the Admin user cannot be deleted.