ACC2: Database Documentor Incorrectly Reports Permissions

ID: Q119654

The information in this article applies to:

Microsoft Access 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

Open the sample database NWIND.MDB.

From the Security menu, choose Permissions.

Select the Groups option button.

In the User/Group Name box, select Users.

In the Object Name box, select the Categories table.

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.)

Choose the Assign button and then the Close button.

From the File menu, choose Add-ins then choose Database Documentor.

In the Print Definitions Of Objects box, select the Categories table, and then choose the Select button.

Choose the Options button and then make sure that the Permissions By User And Group check box is selected. Choose OK.

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.

REFERENCES

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

Additional query words: secure

Keywords : kbusage RptOthr
Version : 2.0
Platform : WINDOWS
Issue type : kbbug