command button password

[Guest]

How can I assign a password on a control button which opens a swithboard
form? I need to have a password assigned to a form which will have various
buttons to print preview reports.

 

[Rick B]

Why not implement user-level security and apply proper security to the
various objects so that only authorized users can open them?

Access comes with user-level security so you don't have to create home-grown
scenarios like the one you mentioned. What would prevent the user from just
going straight to the database window and running the report?


Rick B

 

[Guest]

Now all I have to do is find out how to "implement user-level security and
apply proper security to the various objects." In Access, do you what topic
I would look up? I will try "user-level security" when I get to work.
THANKS!

 

[Joan Wild]

Now all I have to do is find out how to "implement user-level
security and apply proper security to the various objects." In
Access, do you what topic I would look up? I will try "user-level
security" when I get to work. THANKS!

Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

security newsgroup
microsoft.public.access.security

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm