CODEWITHSUNDEEP
ms-accessms-access-2007
confusedMind
confusedMind

Reputation: 2653

How to make user input a password field access query?

I have made an access query to show some client records, the where condition is basically enter the name and a password, i achieve that by using :

WHERE (((Contractor_Appointments.Consultant) Like [Enter Consultant's Name here] & "*") AND ((Contractor_Appointments.Lead_Status) Not Like "Satisfactory") AND ((Consultants.Passwords)=[Enter Password]))

But the things is i want it to treat the password field as a password and put * instead of character when i am typing . Is this possible?

Thank you

Upvotes: 1

Views: 2202

Answers (2)

HansUp
HansUp

Reputation: 97101

Create a new form. Add a text box control. On the property sheet for the text box, select the Other tab and change the Name property to txtPassword. Then, on the Data tab, use Password as the Input Mask property. Save the form as frmPassword.

WHERE
    (((Contractor_Appointments.Consultant) Like [Consultant's Name] & "*")
    AND ((Contractor_Appointments.Lead_Status) <> "Satisfactory")
    AND ((Consultants.Passwords)=[Forms]![frmPassword]![txtPassword]))

Then, open frmPassword in Form View, type in your password and open the query.

If that outline is close to what you want, it can be refined further. But first see if this suggestion is close.

Upvotes: 1

Fionnuala
Fionnuala

Reputation: 91356

This looks fairly imaginary in terms of security. However, you can use a form to get the password. At least that way you can do some checking before running it into your database.

Upvotes: 0

Related Questions