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

--
Kahuna
------------

Tools>Analyze>Documenter

Do not forget to set the Options... as you need for your situation.
--
Hope 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.



"Kahuna" wrote:

> 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
>
> --
> Kahuna
> ------------
>
>
>

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?

--
Kahuna
------------
"Daniel Pineault" <(E-Mail Removed)> wrote in
message news:718265B6-DCA1-41F1-B3D1-(E-Mail Removed)...
> Tools>Analyze>Documenter
>
> Do not forget to set the Options... as you need for your situation.
> --
> Hope 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.
>
>
>
> "Kahuna" wrote:
>
>> 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
>>
>> --
>> Kahuna
>> ------------
>>
>>
>>

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/acc.../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
----------

"Kahuna" wrote in message:
news:(E-Mail Removed)...

> 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?

"Jeff Conrad [MSFT]" <(E-Mail Removed)> wrote in message
news:%23TC3$(E-Mail Removed)...
> 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/acc.../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
> ----------
>
> "Kahuna" wrote in message:
> news:(E-Mail Removed)...
>
>> 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?
>
Jeff - that's was EXACTLY what I was looking for.

That's a blinding bit of software - thanks Bud!

--
Kahuna
------------

"Kahuna" wrote in message:
news:%(E-Mail Removed)...

> 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.
;-)

--
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
----------

"Jeff Conrad [MSFT]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Kahuna" wrote in message:
> news:%(E-Mail Removed)...
>
>> 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.
> ;-)
>

Damn fine club it is too ;-)


--
Kahuna
------------