How to make create username and password?

[eneyardi]

I want to make create username and password and theres an option also that password can be change in order to avoid unauthorized use of the program.

[neelsfer]

Import the form and table into your application and make it the start-up file.I found it on the net, and it works for me

[neelsfer]

access 2003 version of it
add the form to be opened in the VBA; change my current form name

[patjones]

Hi eneyardi,

It's basically a matter of setting up a table with a user name column and password column, and then creating a form with corresponding text boxes. The form is the first thing that opens when the database opens, and if what the user types in the boxes does not match what is in the table, you can raise a message saying that the information is incorrect.

Also consider using some kind of encryption algorithm to store the passwords in a secure manner within the table. For example, there is the MD5 hash which I use in a couple of my applications, but there are probably even more secure algorithms out there.

Pat

[eneyardi]

thanks a lot for your reply, i know that thing, i already made a form related to your suggestion. But i want an option in the login form that the users are able to change and save their password.

[patjones]

Hi eneyardi,

I guess that's really more a question of how to design the log-in form than anything else.

What I might do in this situation is to have a check box on the form that the user can click indicating that he/she wants to change the password. After entering their current password, you can open up two other text boxes on the form: the user would then need to type their new password correctly in both boxes for it to be changed. Clicking an appropriately placed command button would run an UPDATE query to actually change the password in the table.

There are certainly other ways to accomplish this, but I think the method that I'm pointing out is pretty standard.

Pat

[malcolmk]

spot on eneyardi :)
Used the same method myself numerous times.
Simple and reliable.

[eneyardi]

Thanks alot..

[hedwards]

Thanks for the information. How do you apply user privileges to this? In other words, how do I ensure someone with User Privileges only can add and edit data in forms with no access to tables, queries, forms, Macros, etc. and Admin has ability to full database tools?

Thanks

[twinnyfo]

hedwards,

Please refer to this article on How To Create User Permissions and Customized Menus in MS Access. This should be helpful.

[Cafedude]

@neelsfer
Hello... I am hoping you are still around. I have a question about the use of your sample database.

When I go into the code to choose the splash screen name, it does not go to the splash screen. It pulls up the table view. Any ideas?

Thanks
Mike