Password on specific form?

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

How can i set a password for a specific form? Is it a idea to store the
password in a table (passwordID, password) so a user can easy change the
password (if necessary) throug a password form (that is procted by the
password).

Thanx for any tips.

Regards,
Harmannus
 
Have you researched the security features in Access to
control which forms can be used by which users.

You should only use a password approach to control who has
access to the application.

Hope That Helps
Gerald Stanley MCSD
 
Hallo,

I have a table that has 2 forms: 1 with name, address etc. and 1 with
salary. This form has to be protected.

Can this be doen?


Regards,

Harmannus
 
Yes , by setting up two user groups and by allowing only
one of the groups access to the form that requires
protection. That way, only those users you have placed in
that group will have access to the form.

This can all be done using the security features.

Hope That Helps
Gerald Stanley MCSD
 
Hallo,

Can't i do this from VBA code? I rather would keep it simple. E.g. in the on
open event a pop-up screen that asks for a password based on the table
password....

Regards,

Harmannus
 
See these knowledge base articles:
1 -http://support.microsoft.com/?id=209871
2 -http://support.microsoft.com/?id=179371

Jim
 
Back
Top