MS Access Form to prompt for username and password for an approval

[lbradbury]

Hello,

I have a database that I'm developing for a purchase requisition, I have the form mostly designed. I have field that will require a username and password input. I'm just not sure how to do that, when the field is clicked to approve the form, to prompt for a username and password.

 

[jackd]

You may get some ideas from this youtube video by Steve Bishop and/or this one.

 

[lbradbury]

I guess, I'm more asking of having a field on a form, that when clicked prompts for a username and password and looks to the table for validation.

 

[xenou]

At its most basic, you can just lookup the password in a table.
Probably the pieces you would (or could, rather) use are:

• environ("username") - (in the vba form code) to get the current logged in users name (unless you want to have your own login names in the database in a Users table)
• DLookup() - (in the vba form code) to lookup the password entered in
• a way to hide the password that is being typed in ( so it looks like ********* ) but I don't recall how to do this in Access
• a Users table to store loginname/passwords
• Hide the table from easy view (minimally)

It is difficult to overstate how weak and insecure this all is. But that would be the basics.

A more robust method (if you have the time and energy) has been posted here:

Tutorial -- An Access menu / permissions system

This is a post to put in one place an approach I use for giving different access levels to different groups of users in your Access databases. It also provides a flexible menu that adjusts to the user's permissions. It does not require the users to log in: their Windows login name is captured...

www.mrexcel.com

 

[welshgasman]

• a way to hide the password that is being typed in ( so it looks like ********* ) but I don't recall how to do this in Access

Input Mask. Password option