In a nutshell, how does Microsoft Access security work?
The Microsoft Jet database engine, which Microsoft Access uses to store and retrieve its objects and data, employs a workgroup-based security model. Every time the Jet database engine runs, it looks for a workgroup file, which holds information about the users and groups of users who can open databases during that session. Any valid file name can be used, such as Wrkgrp_Sec.mdw. The workgroup file contains the names and security IDs of all the groups and users in that workgroup, including passwords. There are built-in groups (Admins and Users) and a generic user account (Admin) that every workgroup contains by default. The built-in group Guests and user account Guest, which are included in Microsoft Access 2.0 only, can be ignored. You can add new groups and new user accounts using Microsoft Access menus or through code. The Admins group is always present and its users have Administer rights that cannot be revoked. You can remove rights from the Admins group through the menus or throug
