I am trying to run a report through access.  I want a list of users, and the groups that they are a part of.  I am tapping into the tables:  dbo_USERS, dbo_USERGROUPS.  Does anyone know which table actually shows the groups by name?  In the user groups table, it only shows an ID.

Thanks.

The USERS table contains the names of the groups.

Drew 

Which product is that? In RE, the security group names are in the SECURITYGROUP table.

However, since I don't see a USERGROUPS table - I might misunderstand the context of the question.

Mitch
 

Thanks, but i have that table, and it does not include the groups.  I am currently using the following SQL: 

 SELECT dbo_USERS.USERSID, dbo_USERS.USERSID, dbo_USERS.SUPERVISOR, dbo_USERS.NAME, dbo_USERS.DESCRIPTION
FROM dbo_USERS INNER JOIN (dbo_GROUPS RIGHT JOIN dbo_USERSGROUPS ON dbo_GROUPS.GROUPSID = dbo_USERSGROUPS.GROUPSID) ON dbo_USERS.USERSID = dbo_USERSGROUPS.USERSID;

The fields in the user groups and groups tables are empty.  Is there another table that i should be referencing?  I was told, Security Groups table, but i cannot seem to find it.

I'm not sure why you can't find it. You might want to try relinking to the RE7 database. I don't use Access for this, but I just tried it and I could see all of the security tables.

Hmmm...

Mitch

This is the SQL I use to extract the groups/users from RE

SELECT     dbo.SECURITYGROUP.NAME AS GROUPNAME, dbo.USERS.USER_ID, dbo.USERS.NAME
FROM         dbo.SECURITYGROUP INNER JOIN
                      dbo.SECURITYUSER ON dbo.SECURITYGROUP.SECURITYGROUP_ID = dbo.SECURITYUSER.SECURITYGROUP_ID INNER JOIN
                      dbo.USERS ON dbo.SECURITYUSER.USERS_ID = dbo.USERS.USER_ID
WHERE     (dbo.USERS.DELETED = 0)

 
This is on a standard RE 7.71 installation so should work for you.

Regards

Wayne Tarr
Breast Cancer Care
London