By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

How to make create username and password?

100+
P: 180
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.
Dec 7 '10 #1

✓ answered by 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

Share this Question
Share on Google+
10 Replies


100+
P: 547
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
Attached Files
File Type: zip logon db.zip (51.5 KB, 1954 views)
Dec 7 '10 #2

100+
P: 547
access 2003 version of it
add the form to be opened in the VBA; change my current form name
Attached Files
File Type: zip logon db 2003.zip (20.5 KB, 992 views)
Dec 7 '10 #3

patjones
Expert 100+
P: 931
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
Dec 7 '10 #4

100+
P: 180
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.
Dec 8 '10 #5

patjones
Expert 100+
P: 931
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
Dec 8 '10 #6

P: 79
spot on eneyardi :)
Used the same method myself numerous times.
Simple and reliable.
Dec 8 '10 #7

100+
P: 180
Thanks alot..
Dec 9 '10 #8

P: 1
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
Mar 26 '19 #9

twinnyfo
Expert Mod 2.5K+
P: 3,257
hedwards,

Please refer to this article on How To Create User Permissions and Customized Menus in MS Access. This should be helpful.
Mar 26 '19 #10

P: 1
@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
3 Weeks Ago #11

Post your reply

Sign in to post your reply or Sign up for a free account.