Restricting access to certain records

[jjdoro]

I have an employee database that I would like to put into a shared folder to allow Department Heads to view data on employees in their department. However the Department Head should only be able to view data on his/her employees. Is there a way to limit users so they can only access certain records?

 

[JeremyNYC]

Yes.

Implement user-level security (FAQ is on my website, with everything you need to know about how to do so). Add a field (to the table you want to restrict) that indicates which group should be able to view the record. Make the queries that reveal this data use, as a parameter, the manager's group, determined by their logon.

It will take a while to get this up and running, and will require lots of testing, and some careful design of your data structure. But once you nail it, it should be pretty solid.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[jjdoro]

Thanks you Jeremy you have been most helpful :-D