how to set up record-level security

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shirley - 20 Apr 2007 20:20 GMT

I have a master database containing data of multiple departments. I would
like to set up the security so that the department can only access its own
department data but not others after log-in.
The problem is that all the data is in one single table. Is it possible to
set up security to allow people access only some records within in table? In
other words, is there a way to set up record-level security but not
table-level security?
Thanks a lot.

Reply to this Message

Ed Metcalfe - 21 Apr 2007 22:37 GMT

>I have a master database containing data of multiple departments. I would
> like to set up the security so that the department can only access its own
[quoted text clipped - 5 lines]
> table-level security?
> Thanks a lot.

Shirley,

Yes and no.

Jet does not provide any native way of doing this however providing the
record's department is identifiable from one of the fields (the record
creator's user ID, department ID, etc) you can always check the user's login
ID when a form is opened and apply a default filter in the form's On Load
event.

Ed Metcalfe.

Reply to this Message

Shirley - 23 Apr 2007 14:30 GMT

Thanks for the response.
But how can I link the filter of the form to log-in names and passwords?

> >I have a master database containing data of multiple departments. I would
> > like to set up the security so that the department can only access its own
[quoted text clipped - 17 lines]
>
> Ed Metcalfe.

Reply to this Message