Working with User Information in your Team Solution

The user directory, which exists in the modUserList table in the modSystem database, stores information about the Microsoft Windows NT® domain users and groups who have access to the server and the team solutions. It includes details such as e-mail addresses, telephone numbers, and managers.

The user directory also stores additional data for each user that can be automatically synchronized from your Microsoft Exchange Server directory, or, if you are not using Exchange Server, it can be entered manually. The server administrator maintains the information in the user directory. For details, see Managing Users and Roles in the Access Workflow Designer Administrator's Guide.

When you register your team solution, a view is created in your solution database based on the modUserList table. This modUserList view can be used to make user information available in your team solution when the solution is taken offline. When a team solution is taken offline, this view becomes a table, and all of your references to this object continue work.

The user information supplied in the user directory makes it possible for you to implement solution features, such as:

Sending e-mail notifications to a valid user or group. Use script to notify specific users or groups automatically when events are triggered in the solution.
Displaying the full name of the person associated with a security account. Stored user information can be queried by the solution to display full names of the valid users instead of only their Windows NT account names.
Escalating issues to a manager. Look up a user's manager in the user directory, and send e-mail or assign the issue to the manager.

For information about	See
How the modUserList table is created and how it is made available to your team solutions	The User Directory
The options available for user information security	User Directory Security Considerations
How user information works when the solution is taken offline	User Directory Offline Considerations
Creating and using roles for database security	Creating Database Roles
Details stored in modUserList table	The modUserList Table

Note There are a few special considerations when using Microsoft Windows® 95 or later. For more information, see Special Considerations when Using Windows 98.