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]

"Elainie" <El**************@bsc.wales.nhs.ukwrote in message
news:a4**********************************@l6g2000p rm.googlegroups.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