How To: Print a list of objects / permissions for a Group

  • Thread starter Thread starter Kahuna
  • Start date Start date
K

Kahuna

Hi Folks - looking back at an old database app and I need to produce a list
of Tables, Forms and Queries with the permissions on each for a specific
Group.

I can grab them by hand (though there is in excess of 1k objects) but that
would be laborious.

Any suggestions on the simplest way to create a report with these details -
perhaps using a query?

Appreciate any feedback on this one.

Cheers
 
That's not quite what I'm looking for Daniel. My forms alone generate 2993
pages of reports in the documenter - and the Group information is not really
specific.

What I need is a report listing Forms (and other objects) together with the
Permissions held by each Group (on the object).- in a cross tab format I
guess.

Any further ideas on it?
 
It might not be everything you're looking for, but my CSD Tools Add-in might assist with this. One
of its many functions is to help document permissions and groups. You can find the free add-in on
this page of my site:
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

Hope you find it useful,
--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
Jeff Conrad said:
It might not be everything you're looking for, but my CSD Tools Add-in
might assist with this. One of its many functions is to help document
permissions and groups. You can find the free add-in on this page of my
site:
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

Hope you find it useful,
--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
Click to expand...
Jeff - that's was EXACTLY what I was looking for.

That's a blinding bit of software - thanks Bud!
 
in message:
Jeff - that's was EXACTLY what I was looking for.

That's a blinding bit of software - thanks Bud!
Click to expand...

Excellent, I'm very glad to hear you found my add-in useful for your
project. A lot less pages than the Documenter don't you think. <g>

You're now bound to the terms of use - welcome to the Access Junkie club.
;-)

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
Jeff Conrad said:
in message:


Excellent, I'm very glad to hear you found my add-in useful for your
project. A lot less pages than the Documenter don't you think. <g>

You're now bound to the terms of use - welcome to the Access Junkie club.
;-)
Click to expand...

Damn fine club it is too ;-)
 
Back
Top