View Full Version : Security Summary Query requested


MrTibbs
10-26-2001, 05:05 AM
I'm trying to keep user level security organised between 40+ users and 10+ databases. Could someone please post a security query which summarises the security (similar to the documenter) but in a simpler format listing the settings in a single line for each item e.g.
item user or group rights mask
If anyone can point me in the right direction i'll gladly post the results.

SteveA
10-30-2001, 03:37 AM
Check out article Q179703 in the Microsoft Knowledge Base. It discusses custom security reporting for Access 97.

HTH
SteveA

MrTibbs
10-31-2001, 10:22 AM
Good job i've got an old copy of Technet. Couldn't find Q179703 on Microsoft's site.
It's a useful start. Thank you.