Permissions in a shared database

[tascheffers]

I would like to give some of my co-workers access to a database, but would
like to limit that access to updating records only and printing pre-defined
reports. Any suggestions?

Regards,
Tammy

 

[Joan Wild]

I would like to give some of my co-workers access to a database, but
would like to limit that access to updating records only and printing
pre-defined reports. Any suggestions?

You can accomplish this by implement user-level security. Download and
study the security FAQ
http://support.microsoft.com/?id=207793

Follow the steps outlined exactly, or your database won't be secure.

You may also find the Security Whitepaper helpful in understanding security.
http://support.microsoft.com/?id=148555