how to set up record-level security

[Guest]

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.

 

[Ed Metcalfe]

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.

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.

 

[Guest]

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