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

"Elainie" <Elaine.Macintyre [at] bsc.wales.nhs.uk> wrote in message
news:a4770242-5676-4d31-9e62-dee1a271b885 [at] l6g2000prm.googleg roups.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