User-Level Security

[KLR]

I have tried using the help file and Wizard but don't think I can get
to the stage I want.

I have a database which functions as a communication tool for my
company - it is split into 4 sections - Research, Policy, Unit Heads
and Institution Contacts. These are represented by command buttons on
a form that take you to another form with relevant functions for those
areas. I want to give members of Research access to all areas of the
database, whereas all other users should have restricted access i.e.
not be able to access some of the forms within the Research section.

Is it possible to do this with User Level Security? I don't really
understand what happens when you go through the wizard and get to the
secure database objects sections.

Thanks

 

[Lynn Trapp]

Yes, you can use User level security to do this. You will need to get a copy
of the Security FAQ, read it several times, and follow it to the letter.
There is a link to it 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