Access security issue (1 Viewer)

[robert693]

Hello,
I am creating a database with employee records. The database will be used by department managers. I want the database to show only those employee records that are in the department that pertains to the manager that has signed into the database. When a different manager signs in he or she will then see only the employee records from their department. I would like to know if I could do this by using queries somehow?

Thank you for any help!

 

[gemma-the-husky]

you can do all this, but its tricky

normal access security will protect you vertically, if you like

eg, it will stop certain classess of employees opening a particular form or group of forms

but it won;t limit what they can see within a form they can open.


To do that you need to look at each query, and write it in such a way that the query filters the records for you. You may also need some "master" users who can see evertything. Its likely to become time consuming developing this.