ACC2: Database Documentor Incorrectly Reports Permissions

• Microsoft Access version 2.0

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.

MORE INFORMATION

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.

REFERENCES

For more information about the Database Documentor, search for "Database Documentor," and then "Database Documentor Command" using the Microsoft Access Help menu.