How can I retrieve the “most restrictive” permissions for attached tables?
This is a multi-step process but can be useful in setting the Enabled property of command buttons that might rely on a recordset being updateable. First, you must retrieve the explicit permissions for the specific user of the table. Then you must add all group membership or implicit permissions. This step must be done separately for both the current database and the remote database. Once both sets of implicit rights are computed, the two are merged using a binary AND operator. This will leave only the bits that are set in both sets and forms the “most restrictive” set of permissions. Microsoft Access 2.0: If the current user is not a member of the Admins group, this information can be tricky to obtain. See Section 23, “How can I obtain the groups that the current user belongs to without hard-coding an Admins ID and password in the code?” for a workaround. Microsoft Access 95, Microsoft Access 97, and Microsoft Access 2000: A new security setting was added that permits users to retrieve
