Microsoft KB Archive/119654

= ACC2: Database Documentor Incorrectly Reports Permissions =

Article ID: 119654

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q119654





SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.

The Database Documentor in Microsoft Access version 2.0 incorrectly reports permissions for the Users group and any new groups that you create. This problem also occurs with the Print Definitions command.



RESOLUTION
There is no known resolution to this problem at this time.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs with Microsoft Access version 7.0.



Steps to Reproduce Problem

 * 1) Open the sample database NWIND.MDB.
 * 2) From the Security menu, choose Permissions.
 * 3) Select the Groups option button.
 * 4) In the User/Group Name box, select Users.
 * 5) In the Object Name box, select the Categories table.
 * 6) Assign full permissions to the Users group on the Categories table. (Select the Read Design, Modify Design, Administer, Read Data, Update Data, Insert Data, and Delete Data check boxes.)
 * 7) Choose the Assign button and then the Close button.
 * 8) From the File menu, choose Add-ins then choose Database Documentor.
 * 9) In the Print Definitions Of Objects box, select the Categories table, and then choose the Select button.
 * 10) Choose the Options button and then make sure that the Permissions By User And Group check box is selected. Choose OK.
 * 11) Choose OK to generate the Object Definition report. Note that for permissions for the Users group, the Database Documentor reports "Read Permissions," which is incomplete for this table.

This problem also occurs if you create a new group and assign full permissions on a table to the group.

