Password Protect OnClick button?

  • Thread starter Thread starter Rachel
  • Start date Start date
R

Rachel

Is there an easy way to password protect the popup form
when a button is pressed? I'd also like the table that is
the source of the form to be password protected as well.
It doesn't matter whether those two passwords are the same
or different.

Thanks,
Rachel
 
Hi Rachel

It is not possible to protect anything properly with popup password forms,
particularly if your users have access to the database window. To provide
proper protection you must implement user-level security. This has the
added advantage that the user will be asked for the password only once, when
the application is started, instead of having to respond to a popup every
time they want to do something.

The User-level Security Wizard will provide you with a good start. I also
*strongly* urge you to read the Access Security FAQ (see
http://support.microsoft.com/support/access/content/secfaq.asp) at least
twice, and then have a good night's sleep and read it again. Also, be sure
to take a backup copy of your database before you start in case you need to
return to square one.
 
Back
Top