469,275 Members | 1,802 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

How to make create username and password?

180 100+
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

10 13790
neelsfer
547 512MB
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, 2014 views)
Dec 7 '10 #2
neelsfer
547 512MB
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, 1036 views)
Dec 7 '10 #3
patjones
931 Expert 512MB
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
eneyardi
180 100+
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
931 Expert 512MB
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
spot on eneyardi :)
Used the same method myself numerous times.
Simple and reliable.
Dec 8 '10 #7
eneyardi
180 100+
Thanks alot..
Dec 9 '10 #8
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
3,653 Expert Mod 2GB
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
@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
Jul 29 '19 #11

Post your reply

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

Similar topics

9 posts views Thread by deko | last post: by
4 posts views Thread by Lobang Trader | last post: by
12 posts views Thread by Cecil | last post: by
5 posts views Thread by livefreeordie | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.