I have a client who as asked me to do some updates to their application. One of the things they have asked is that I 'secure' the Password filed in their login form.
I know there is a InputMask type of Password, which obscures the text typed into the Textbox on the form. Also, this InputMask can be applied to the text field of the table which holds the password.
The login form takes the field.text values for the username and password fields on the form, then builds a query string and performs a select statement via ADODB which is the functional equivalent of the following psuedo-code:
"select table.password from table where table.username= form.username.text and table.password= form.password.text;"
If the returned recordset.recordcount > 0, there is a successful login.
This configuration works fine as long as the InputMask propeties (in the form, AND in the table) are NOT set to password. If Either, or BOTH of the InputMasks are set, the query fails.
I have confirmed using breakpoints, and the immediate window, that the information being collected from the form is correct, however I cannot determine why the select lookup is failing.
Any thoughts on the matter are greatly appreciated!