User Permissions for a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database tracking quality control inspections for repaired vehicles.
I have a table for shop codes / employee man # / and service records wich
contains data about vehicle #, date inspected , pass or failed / why failed.
I have relationships for shop codes and employee man numbers so I can see
quickly what vehicles a person worked on. The problem comes I have is that I
need to set permissions for each shop supervisor so they can only see their
shops data.

I have created a report for each section with a query for their shop code,
but in order to for them to see the report I have to give them read
permission for the all tables that the info in drawn from on the report and
now they can see all the data on the tables and it just blocks them from
viewing the other shops report. If they just open the tables then they can
see all data. Can anyone help on this?
 
Ron,
If you implement User Level Security you can remove all permissions to the
tables and create Read With Owner's Permissions queries to base your reports
on. Then you give your users the necessary permissions to the RWOP query and
they can run their report just fine but cannot open the table. The
instructions for this are in the Security FAQ. You can get a copy of it on
the Security page of my website. Read it several times and follow it to the
letter.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
Back
Top