User Level Security

User-level security is a relatively complex process that secures the code and objects in your database so that users can't accidentally modify or change them. With this type of security you can provide the most restrictive access over the database and objects it contains. When you use user-level security, the Microsoft Jet Engine uses a workgroup information file to determine who can open a database and to secure its objects.

The workgroup information file holds group and user information, including passwords. The information contained in this file determines not only who can open the database, but also the permissions users/groups have on the objects in the database. The workgroup information file contains built-in groups (Admins and Users) and a generic user account (Admin) with unlimited privileges on the database and the objects it contains. For more information on the workgroup information file, refer to the following two sections of this chapter.

The Microsoft Office Access user interface provides four commands on the Tools | Security menu that allow you to manually implement user-level security. You can also define user and group accounts and their passwords from your VBA procedures by using ADO code, as demonstrated later in this chapter.

0 0

Post a comment