Limit user access to reports/data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CKAFO - 14 Jun 2007 19:54 GMT

Is there any way in Access 2003 to give someone access to run a set of
reports without allowing them access to the tables? And if the only way is
to create user and group accounts, is there a dummies version of how to do
this. I have read the help and can't make heads or tails about how to set
that up. Thank you.

Signature

CKAFO

Reply to this Message

John W. Vinson - 15 Jun 2007 02:29 GMT

>Is there any way in Access 2003 to give someone access to run a set of
>reports without allowing them access to the tables? And if the only way is
>to create user and group accounts, is there a dummies version of how to do
>this. I have read the help and can't make heads or tails about how to set
>that up. Thank you.

Download the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Read it carefully. Get a good night's sleep; read it... *again*.

Yes, you can do this. It's not even all that hard, but it's *very* picky and
must be done right! Go through the FAQ as a checklist, and make sure you give
the users Run privileges on the reports but nothing on the Tables or Queries.

John W. Vinson [MVP]

Reply to this Message