reports level security in Access

  • Thread starter Thread starter roger
  • Start date Start date
R

roger

Hello friends

Can we like put an object level security in Access whereby
say some users can use some reports and other users cannot
use some reports?
 
You can secure your database. The built in security will thus let
you setup a set of groups.

You can have sales force group, accounting group, manager group etc.

Then when you create your reports, you assign each report to one of the
above groups. Only users that belong to the given group(s) will be able to
use, and view the report. So, the built in security system is ideal for what
you want.

Once the security is setup, then the above is real easy to do. However,
setting up security the first time is quite difficult. It can easily be a
good day of your time. (and worse, the first few times you likely will mess
things up!).

You can find a good article in access security at the following page:

http://www.mvps.org/access/resources/techpapers.htm
 
Back
Top