Viewing Access 2003 Group Permissions

  • Thread starter Thread starter maryanne.moore
  • Start date Start date
M

maryanne.moore

I have a secure Access 2003 database with multiple users and groups.
There are lots of forms, reports, queries, etc. When I go to Tools-
Security->User and Group Permissions and click on Groups there is a
Click to expand...
listbox of group names and a listbox of object names. Does anyone
know if there is a way to sort the list of object names by name? I
believe it may have been sorted that way originally, but over time
with new versions of many objects created or imported, the list is no
longer in any meaningful order. There also appears to be no way to
increase the width of the listbox to view the entire name when it is
long. This makes it difficult to differentiate between
rptPaymentStatement_OwnersInState and
rptPaymentStatement_OwnersOutOfState.

Alternatively, does anyone know how to query the group permissions on
an object? If you use the built in documenter (Tools->Analyze-
Documenter), you can select a set of objects and uncheck all the
Click to expand...
options except user and group permissions, but this results in a
report that displays each object on a separate page with both user and
group permissions. I'd like something much more concise, like a list
of objectName, GroupName, Permission. It would seem that, as an
admin, I could get this in a query if I only knew what to query for.
Anyone know?
 
Back
Top