Re: What permissions does this security group have?

Hi, Rachel.

Use the built-in Access Documenter. Select the Tools menu -> Analyze ->
Documenter to open the Documenter dialog window. Select the "All Object
Types" tab. Select the "Select All" button to check all objects.

Highlight one of the table names. Select the "Options" button to open the
"Print Tables Definition" dialog window. Uncheck the "Properties" and
"Relationships" check boxes and select "Nothing" options for both the
"Include for Fields" and "Include for Indexes" sections. This will leave
the "Permissions by User and Group" as the only item to be documented.
Select the "OK" button to save these changes.

Highlight a query name and follow the above steps to document only the
"Permissions by User and Group" for the queries. Do this for every type of
database object.

Next, uncheck "Relationships" and "Properties" check boxes.

Select the "OK" button to create the report of User and Group permissions of
all objects in the database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Rachel" <Rachel@discussions.microsoft.com> wrote in message
news:04AE60CC-3110-453F-B910-937753777318@microsoft.com...
> I just inherited an Access 2003 database that already has security groups
set
> up. How can I determine what permissions the security groups have been set
up
> with?