how do i mask the text i type into a form in access?

[Guest]

The idea behind this is to create a user login form. I am having many
problems. I want a list box for the username, where the usernames and
matching passwords are in a table. I am a newbie, and have no idea how to
create the necessary IF statement or how to create a login button. The idea
is for the user to select the relevant username, type in their password and
be redirected to their own personal area (personalised form). If login
fails, I wish for a message box to be displayed. Please help!

 

[Rick B]

I bet you are having problems.

Access has built in user-level security. Why are you reinventing the wheel?

Your version will not be secure. Where will you store the passwords? In a
table? What is to keep your users from opening the table and seeing them?

As posted many many many times in these databases, home-grown security is a
bad idea, not secure, and wastes a great deal of your time trying to create
a solution that is already built into the software.

I suggest you read the security FAQ and follwo the instructions to secure
your database properly.

Rick B



Some good reading....

Security FAQ

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



The Security Whitepaper is also worth reading to help you understand.

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



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm