sql - Listing the permissions of a specific user or group in an MS Access security file? -

i'm trying set permissions groups in our ms access database using *.mdw security file.

i'm on "user , group permissions screen", , not ideal finding out permissions have been set user concerning specific object.

i'm given list of users/group names , have no trouble finding group there.

however...when reach object name: list, ridiculously long , unable find permissions have been assigned group due enormous number of objects found there.

the existing group has limited set of permissions (it appears of objects permissions checkboxes unchecked), there @ least thousand of these each of object types: table, queries, forms, etc...and find out ones have read data, or open/run checked off permissions.

i've tried scrolling though object name:s group there many check without sort of query or code; there must way this.

i don't have access main account database, don't believe able write code find answer.

i able obtain list of objects using a query specified here unable find relation between objects , group permissions.

frankly user interface clunky , understand trouble!

to set permissions group, switch groups option under user/group name list.

the permissions assigned object shown combination of check boxes can make hard see current permission set up.

select group want modify , use object name list select object(s). list multi-select if want give permissions few objects, best way select whole list , clear permissions , set permissions selected objects.

so, instance, assign read-only permissions group apart 2 tables have read/write permissions, set object type 'table'. select entire list of tables including '' item in object name list , clear of check boxes apart read data , read design (you can't clear read design if have read data selected). click apply button. select 2 tables want give read/write permission in object name list. check update , insert boxes , click apply.