password for a form

[alpapak via AccessMonster.com]

password for a form
------------------------------------------------------------------------------
--

hi
i want to protect a form from the users with a password
users will click the button and a message will apper asking for password

password will be saved in a table so admin can change it in the future

tblPassword
PassID
Password

thxs

 

[Rick B]

Do a search. Asked and answered all the time. Pretty bad idea since users
can get around your password several ways. They could simply open the table
directly and see the data or change it.

I would normally recommend that you use User-Level Security and properly
secure the form. If the user has access to it, then they can get in. If
they don't, then they can't get in. No need to prompt your higher level
users for a secret password everytime they try to do their job.