 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / May 2008How To: Print a list of objects / permissions for a Group
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  SignatureKahuna ------------ Tools>Analyze>Documenter Do not forget to set the Options... as you need for your situation. SignatureHope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.com/index.php Please rate this post using the vote buttons if it was helpful. > 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 [quoted text clipped - 9 lines] > > 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? SignatureKahuna ------------ > Tools>Analyze>Documenter > [quoted text clipped - 16 lines] >> >> Cheers 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, SignatureJeff 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 ---------- > 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. [quoted text clipped - 3 lines] > > 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 [quoted text clipped - 13 lines] >> >> Any further ideas on it? Jeff - that's was EXACTLY what I was looking for. That's a blinding bit of software - thanks Bud! SignatureKahuna ------------ > Jeff - that's was EXACTLY what I was looking for. > > That's a blinding bit of software - thanks Bud! 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. ;-) SignatureJeff 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 ---------- >> Jeff - that's was EXACTLY what I was looking for. >> [quoted text clipped - 5 lines] > You're now bound to the terms of use - welcome to the Access Junkie club. > ;-) Damn fine club it is too ;-) SignatureKahuna ------------
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.