Limit use

[Candace]

I've created user and admin accounts but Access can't seem to differentiate
between the two. I want users to have to log in to the database, not Access
and I want them to have VERY limited access to different areas of the
database. Basically they should only be able to see a form and enter data
into it. How do i do this

 

[Lynn Trapp]

Candace,
Did you read the Security FAQ before you started creating accounts? If not,
you need to go back to square one. There is a link to the Security FAQ on
the Security page of my website. Read it several times and follow it to the
letter.

--
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