Click here to Skip to main content
15,748,615 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi, I could developed employee database.I use as front end and ms access as back end. In single database table i include all employee information (also user id and password). I placed separate log in form for employee. Each person has separate log id and password. I try to structure log in form. But its not connected.
I want help ...........
hitech_s 18-Oct-11 8:37am    
plz provide your code

1 solution

You don't really want the form connected to the database: you want to wait for the user to press the "OK" or "Login" buttons, then validate the data.
The normal procedure is to hold a hashed password in the database (MD5 or preferably SHA) and retrieve the record which has a matching login id. You then generate the hash from the data they have entered (id and password) and compare that to the value returned from the DB. If it matches, they they are ok to login, if it doesn't they aren't.

There is a link here which covers the hashing - it's in C# but it translates easily: Password Storage: How to do it.[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900