Password Protect a Textbox???

[JTQ911]

I am making a database for my company that includes build sheets for items we manufacture. During each part of the bulid process (and on every form) there is a textbox where the Quality Assurance officer's name who is overseeing the manufacturing will be entered. Is there a way to have this textbox password protected in any way, such as by clicking a button which prompts the user to enter a password, such that it acts as a signature.

Sidenote, I only want the Quality Assuranace office to know this password once the feature has been put in place. How would I "hide" or limit access to the table so not every single user of the database would be able to go into the database structure, open the table, and see the password?

I greatly appreciate any help. I'm familiar with Access, but not too much with code. The most specific help would be dearly appreciated. Thanks everyone for even looking.

Regards, Jims

 

[georgedwilkinson]

Hide the table holding his password (several ways to do this). Name it "usysWhateverTheNameOfTheTableWas" and people won't think to look for it since objects beginning with "usys" are hidden by default.

Go into design of the table and set the "input mask" of the field containing the password to "Password". Further, you could encrypt the password. An easy way to do that is multiply each character in the password by 2 before you store it and divide it by 2 when you compare it to the input (as long as you're using 8 bit characters).

Lots of other things you could do to obfuscate. But keep in mind that Access is not the most secure environment out there.

 

[JTQ911]

Do you know how to actually password protect the textbox though. When the user clicks the textbox, how do I prompt the user to enter the password. Also, once they enter the password, how does it check it against the table where the passwords are stored etc etc etc?