Form Security

[Elainie]

I have a managers menu, which I would like 2 managers to open when
they want to update some tables with new users etc.

I was thinking of putting a message on the button to say that if you
are not a manager then you should not access that form, then close the
form down.

How can I do this? I have searched all over for information about
Form Security within MS access 2003 but cant find any.

Has any one got any ideas, how can I stop users going into the
managers form so that they dont play with the data that the manager
has put in?

E

[Fred Zuckerman]

Re: Form Security

"Elainie" <Elaine.Macinty re@bsc.wales.nh s.ukwrote in message
news:a4770242-5676-4d31-9e62-dee1a271b885@l6 g2000prm.google groups.com...

>I have a managers menu, which I would like 2 managers to open when
they want to update some tables with new users etc.
>
I was thinking of putting a message on the button to say that if you
are not a manager then you should not access that form, then close the
form down.
>
How can I do this? I have searched all over for information about
Form Security within MS access 2003 but cant find any.
>
Has any one got any ideas, how can I stop users going into the
managers form so that they dont play with the data that the manager
has put in?
>
E

Your best option is to implement user level security and then use
CurrentUser() or Group Permissions to determine who is allowed into the
form. An easier (ie: less secure) method would use API calls to LoginName or
ComputerName to assess permission. An even easier (ie: least secure) method
would hard code a password into the Form Open event and give that password
only to the managers.
Fred Zuckerman