By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Form Security

P: n/a
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
Jan 11 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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
Jan 11 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.