MS Access - Passwording Question

Monster Dave · August 19, 2009, 10:47:42 AM

Hey everyone,

I'm trying to secure a password field in an ACCESS table. I've set the input mask to be a password, however as an administration how does one gain access to passwords protected by the input mask?

Thanks!

Monster Dave · August 19, 2009, 12:47:20 PM

Anyone?

cyrus buelton · August 19, 2009, 12:51:09 PM

Quote from: Monster Dave on August 19, 2009, 12:47:20 PM
Anyone?

Do I get a portion of your hourly wage for answering it?

cyrus buelton · August 19, 2009, 12:53:27 PM

Quote from: Monster Dave on August 19, 2009, 12:47:20 PM
Anyone?

Ok, so I am about to leave work so I should answer as I won't look at this thread again until i am drunk, stoned, and methed out.

The input mask should just show up on the forms and not in the table try to put the input mask in the form field and see if it shows up in the table as just the password.

cyrus buelton · August 19, 2009, 12:56:55 PM

I just tested it out and that is the case.

Put the input mask on the form. The password will be visible in the table if the table column is set to text without an input mask.

Monster Dave · August 19, 2009, 01:33:15 PM

Quote from: cyrus buelton on August 19, 2009, 12:56:55 PM
I just tested it out and that is the case.

Put the input mask on the form. The password will be visible in the table if the table column is set to text without an input mask.

Interesting, that was the first thing that I did and was unable to view the PW in the table.....

cyrus buelton · August 19, 2009, 01:57:24 PM

Quote from: Monster Dave on August 19, 2009, 01:33:15 PM
Interesting, that was the first thing that I did and was unable to view the PW in the table.....

I just tried it on a blank database and it worked fine.

that is really odd.

Monster Dave · August 20, 2009, 06:12:43 AM

Quote from: cyrus buelton on August 19, 2009, 01:57:24 PM
I just tried it on a blank database and it worked fine.

that is really odd.

I figured it out this morning while retracing my steps/attempts from yesterday. Essentially I had done what you had suggested before I posted the question, but I had set the input mask to "password" on the table not realizing that the field in the form would have to be set independantly.

It was sort of a Homer "d'Oh!" this morning when I realized it. Sometimes you just can't see the forest through the trees!!

Thanks for the help!

Dave.

cyrus buelton · August 20, 2009, 06:47:14 AM

glad I could help you out.

I suspected you made a "mistake" while doing the input and after re-tracing a few times, you picked up the error.

I do it all the time too.

News:

MS Access - Passwording Question