Password on specific form?

[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

 

[Gerald Stanley]

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

 

[Harmannus]

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

 

[Gerald Stanley]

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

 

[Harmannus]

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

 

[Jim/Chris]

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

Jim

 

[Harmannus]

Hallo,

Thanx! This is what i hade in maind!

Regards,

Harmannus