How to use Application roles with Access projects and SQL Server 2000 Desktop Edition

In SQL Server, you can create database roles for easier administration of permissions in a database. Instead of granting individual permissions to each user separately, you can group users with the same permission needs by making them members of the same

support.microsoft.com