How can I compare two records? (Access)

Question

1.00/5 (1 vote)

See more:

I should create a "Valid" button which once inserted the password inside the cell goes to verify that the password is equivalent to the one already inserted in another table.

Example:

Users table
User A 12345
User B 6789
User C 4785

Hours Mask

User A 8 hours 12345 [VALID] (Right password? Yes, proceed to insert the record. Wrong password? Error.)

(I'm working on Access 2007-2016)

What I have tried:

Honestly, I tried in vain, since I do not understand how to compare the two records.
I tried with VBA ( Ithink, the modules) code but even if I enter the wrong password the record is added the same.

Posted 10-Dec-18 3:46am

Atipos

Updated 10-Dec-18 4:02am

Add a Solution

Comments

CHill60 10-Dec-18 10:23am

Show the VBA code you used to check the records (for now I am ignoring the fact that you should never store passwords in databases)

Richard Deeming 11-Dec-18 11:00am

NEVER store passwords in plain text.

Secure Password Authentication Explained Simply[^]
Salted Password Hashing - Doing it Right[^]

Atipos 11-Dec-18 11:42am

I am aware that it is not a good thing to memorize the password in a plain text. Being a beginner with this type of security I used this method (not convenient). Thank you for the various links, I will read them carefully!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

MadMyche · Accepted Answer · 2018-12-10T04:02:00

User names and passwords are credentials for Authentication. Outside of that, the credentials are no longer needed, so in essence; the second table has no need for the password.

Q: How would I change your process?
A: Validate the credentials against "Table A", and if authentication succeeds, insert the new record into "Table B"