ACC97: Documenter Does Not Display User and Group Permissions

ID: Q176557


The information in this article applies to:


SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

If you run the Documenter on a secured database, and you select the option to display "Permissions by User and Group," the user and group names are displayed, but the permissions to the objects for the user and group are not displayed.


CAUSE

If the database is secured, the Documenter does not allow you to display User and Group permissions for the objects in the database in a report.


RESOLUTION

If you want to display security information about User and Group permissions, you must create a custom report that provides this information.

For example, you can write Visual Basic code that uses data access objects (DAO) to read and store the permissions for the user and group, and then create a report to display that information.


STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97.


MORE INFORMATION

Steps to Reproduce Behavior


  1. Open any secured database in Microsoft Access 97.


  2. On the Tools Menu, point to Analyze, and then click Documenter.


  3. In the Documenter dialog box, click the Tables tab, and then click the Options button.


  4. In the Print Table Definition dialog box, click to select the "Permissions by User and Group" check box, and then click OK.


  5. In the Documenter dialog box, click the Select ALL button.


  6. Click OK to run the Documenter wizard.


  7. Preview the report.

    Note that while all the objects are displayed along with the user and group information, the permissions for the user and group are not displayed.



REFERENCES

For more information about other issues involving the Microsoft Access 97 Database Documenter, please see the following articles in the Microsoft Knowledge Base:

Q166290 ACC: Error Using Database Documenter If Objects Are Open

Q175380 ACC95: "Unrecognized Database Format" Using the Database Documentor

Additional query words: pra


Keywords          : WzOthr 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 23, 1999