Password protect a form and table

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

What do i need to do to password protect a form and protect or hide the
underlying table. Also can one page on a tabcontrol be password protected?
Thanks...Randy
 
For the form, put this one line in the Form_Open event:

cancel = (inputbox ("password?") <> "s3cr3t")

For the table, there's really not much you can do, except to implement
Access "user level security". This is not a task for the faint-hearted. If
you want to know more, locate & study the Access Security FAQ. Plan to spend
at least several weeks - if not >months< - studying that document, before
you will understand it properly.

HTH,
TC
 
Back
Top