Hi,
Am wondering if there is a quick way to generate a report that will print
out group permissions for my database objects.

I can always write them down, but it would be very time-consuming to note
each level of permission for each and every database element.

Any advice would be greatly appreciated!
--
Thanks!

Dee

Hi Dee,

The built-in Documenter can do this:
Tools | Analyze | Documenter

I prefer to use my own tool for this:
http://www.accessmvp.com/JConrad/acc.../csdtools.html

My tool can document many areas of your database and usually with less pages than the Documenter.
One of the tabs on my tool can print user and group permissions. It's also free.

Make sure to follow the instructions and use on a backup copy.

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

"dee" wrote in message:
news:950B83DB-A952-4CA7-B893-ACEFA34415EB@microsoft.com...

> Hi,
> Am wondering if there is a quick way to generate a report that will print
> out group permissions for my database objects.
>
> I can always write them down, but it would be very time-consuming to note
> each level of permission for each and every database element.
>
> Any advice would be greatly appreciated!

Hi Dee,

The built-in Documenter can do this:
Tools | Analyze | Documenter

I prefer to use my own tool for this:
http://www.accessmvp.com/JConrad/acc.../csdtools.html

My tool can document many areas of your database and usually with less pages than the Documenter.
One of the tabs on my tool can print user and group permissions. It's also free.

Make sure to follow the instructions and use on a backup copy.

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

"dee" wrote in message:
news:950B83DB-A952-4CA7-B893-ACEFA34415EB@microsoft.com...

> Hi,
> Am wondering if there is a quick way to generate a report that will print
> out group permissions for my database objects.
>
> I can always write them down, but it would be very time-consuming to note
> each level of permission for each and every database element.
>
> Any advice would be greatly appreciated!

Thanks, Jeff. I will use your tool.

Thanks again!
--
Thanks!

Dee


"Jeff Conrad [MSFT]" wrote:

> Hi Dee,
>
> The built-in Documenter can do this:
> Tools | Analyze | Documenter
>
> I prefer to use my own tool for this:
> http://www.accessmvp.com/JConrad/acc.../csdtools.html
>
> My tool can document many areas of your database and usually with less pages than the Documenter.
> One of the tabs on my tool can print user and group permissions. It's also free.
>
> Make sure to follow the instructions and use on a backup copy.
>
> --
> 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
> ----------
>
> "dee" wrote in message:
> news:950B83DB-A952-4CA7-B893-ACEFA34415EB@microsoft.com...
>
> > Hi,
> > Am wondering if there is a quick way to generate a report that will print
> > out group permissions for my database objects.
> >
> > I can always write them down, but it would be very time-consuming to note
> > each level of permission for each and every database element.
> >
> > Any advice would be greatly appreciated!
>
>
>

Thanks, Jeff. I will use your tool.

Thanks again!
--
Thanks!

Dee


"Jeff Conrad [MSFT]" wrote:

> Hi Dee,
>
> The built-in Documenter can do this:
> Tools | Analyze | Documenter
>
> I prefer to use my own tool for this:
> http://www.accessmvp.com/JConrad/acc.../csdtools.html
>
> My tool can document many areas of your database and usually with less pages than the Documenter.
> One of the tabs on my tool can print user and group permissions. It's also free.
>
> Make sure to follow the instructions and use on a backup copy.
>
> --
> 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
> ----------
>
> "dee" wrote in message:
> news:950B83DB-A952-4CA7-B893-ACEFA34415EB@microsoft.com...
>
> > Hi,
> > Am wondering if there is a quick way to generate a report that will print
> > out group permissions for my database objects.
> >
> > I can always write them down, but it would be very time-consuming to note
> > each level of permission for each and every database element.
> >
> > Any advice would be greatly appreciated!
>
>
>