Creating user level access based on department

[Bill]

This forum has been great and I really appreciate it. I'm looking to expand
my database a step further. We have a database for incident reporting which
tracks things within our facility. For every incident there is a department
assigned.

What I want to do is allow the department heads to open access and view only
their department(s). I am using the windows log in username and passing that
to access. I have a security script which determines the users level based
on a table of read, edit or admin.

Now I want to expand this to filter the reports to those in the department
they are assigned. In some cases, like me for example, I am over several
departments and need to view many. Others will only view one department.

The table everything is stored in is DataSheet and the column for the
department is titled Department.

Any help and guidance you can lend would be GREATLY appreciated!!! Thx.

 

[Bill]

Sorry, I'm not trying to create a report. I need to restrict access to
various areas or tabs bassed on the department the user would be assigned.

 

[Bill]

ok. So I think I get your idea. So let me explain a little more just to
clarify. I have an incident system which when a incident needs to be created
a user logs in and creates it. The incident normally will reference a
department where it occurred. So I want to expand this function now and
allow the department head to log in and see their departments only.

So you are saying, grant the department head access (add a column to the
user table to show which department each person is associated with) then each
time a report or query is ran, it needs a VBscript to determine the
department the user is associated with and then filter the query or report
based on this?

So, I see the concept, but to be honest have I no idea how to create. Thx.

The same query will work for browsing in a datasheet. Set the criteria for
the department based on the user. Are you using the FOSUsername() function?


Bonnie
http://www.dataplus-svc.com

Sorry, I'm not trying to create a report. I need to restrict access to
various areas or tabs bassed on the department the user would be assigned.

If you already have the department captured, base the report on a query that
filters on department.

[quoted text clipped - 20 lines]

Any help and guidance you can lend would be GREATLY appreciated!!! Thx.