Group security

[SF]

Hi,

I have a database which work fairly good except that it does not containt
any security control. My supervisor wants each staff member, who is below
the supervisory level, to look or edit only their own records and each
supervisor can view or edit all the information.

What is the best way to implement this feature.

Right now, I have added a field the store logon name on each table to
identify the record owner. I am not enable to allow the supervisor to edit
or view beside the record owner.

SF

 

[Lynn Trapp]

I would recommend that you take a look at Access User Level Security, which
will allow you to do everything you need. There is a pretty steep learning
curve with it, but it's better than trying to reinvent the wheel. There is a
link to the Security FAQ on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html