Look into using the Access Security Wizard (remember to make a copy of your
database BEFORE using it so you can restore if you lock yourself out).
Here's a link to some good info:
http://www.moretools.com/lessons/access_security.htm

Signature
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
> Can you help me put individual passwords for tables, forms, and reports
> instead of hiding them?