How to restrict printing access for users

A

Amanda

Hello,

I am new to shared databases and was wondering if there was a way to
restirct users from printing specific reports?

Thanks.
 
A

Arvin Meyer [MVP]

You can use User-Level security:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm

or if that's too involved, get the user's Windows login name, and restrict
the report to users who aren't in the list:

http://www.mvps.org/access/api/api0008.htm

If UserName() = "Arvin" Then
DoCmd.OpenReport "rptWhatever", acViewPreview
Else
MsgBox "No soup for you"
End If
 
Top