Re: Database Secuirty

The form is my unbound menu. I have two buttons on the form one for the
user's to change their own passwords and one that's been set up for one of
the administrators to handle passwords (this is the one I'm trying to hide
from everyone but the admins) so there are no relationships setup with this
form. I am using Office 2003. Is there any editing in the code from the
security FAQ that I might need to edit to point to the right place?
--
Lori A. Pong


"Joan Wild" wrote:

I shouldn't make a difference. Check your references in the Tools menu.
Any missing? What is checked? Have you save the form? What version of
Access?

--
Joan Wild
Microsoft Access MVP

Lori wrote:
I get a totally different error "method or datamember not found".
This should be easy, would it make a difference if I did it
backwards? Tell it to hid unless a member of the Admins group is
logged in? --
Lori A. Pong


"Joan Wild" wrote:

try Me.cmdPasswordAdmin.visible = True

--
Joan Wild
Microsoft Access MVP

Lori wrote:
Joan, I've followed all the steps, created the module with the
information from the security FAQ, and used the code as follows:

Private Sub Form_Open(Cancel As Integer)

If faq_IsUserInGroup("Admins", CurrentUser()) = True Then
Me!cmdPasswordAdmin.Visible = True
End If

In order to make sure there is no doubt to the control name and the
caption are the same and I cut and pasted the name to avoid typos,
however everytime I try to view my form I get an error message that
the "database can't find the field "cmdPasswordAdmin" referred to in
your expression"

What am I doing wrong?
--
Lori A. Pong


"Joan Wild" wrote:

I take it you are using the 'switchboard manager' in Access to set
up your menu form.

I suggest you ditch it and instead just create an unbound form.
You can add all the buttons you like, and you'll have more
flexibility than the SM can provide.

There is code in the security FAQ
http://support.microsoft.com/?id=207793 you can use to determine if
a user is a member of a group. In the open event for your form,
use the function and hide various buttons that the group isn't
supposed to see. For example

If faq_IsUserInGroup("EnterData",CurrentUser) then
Me.cmdWhatever.Visible = False
Me.cmdSomething.Visible = False
Else
Me.cmdWhatever.Visible = True
Me.cmdSomething.Visible = True
End If



--
Joan Wild
Microsoft Access MVP

Kit wrote:
I was wondering how do i assign certain previledges to certain
users. For example on my switchboard it has links to all my forms
some which are manager forms and the otehrs which can be used by
all staff. I have run the user level secuirty wizard and assigned
certain previledges such as read only for new users, and full
permissions and full data users. But i want to know how can i stop
certain groups opening certain links from my switchboard such as
manager options??? I am a little confused on this topic. :) all ur
help would be great



.

Loading