Security question

[Mark Reed]

Hi all,
I want to be able to uncheck all the options in the start-up menu so
that along with the workgroup information, all the menu's are removed making
the database even more secure. The problem with that is that I will not be
able to re-instate the menus to do changes should I need to. (Will I?)

With this in mind, is there any way I can create a transparent command
button hidden on one of the forms so that when clicked, then menu's will
re-appear?

Thanks all for your help?

Mark

[Fletcher Arnold]

"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:ygMZb.340$8N6.110@newsfe1-win...

Hi all,
I want to be able to uncheck all the options in the start-up menu so
that along with the workgroup information, all the menu's are removed making the database even more secure. The problem with that is that I will not be
able to re-instate the menus to do changes should I need to. (Will I?)

With this in mind, is there any way I can create a transparent command
button hidden on one of the forms so that when clicked, then menu's will
re-appear?

Thanks all for your help?

Mark

Are these steps being taken in addition to using user-level security? If
so, you could have a tab on a form which only becomes visible if you log in
as a member of the admins group.

Fletcher

[Mark Reed]

Hi,
Yes, this is in addition to user level security.

Are you saying that it is possible to put all the menu's on a form which is
only accessible to Admin users?

Hi all,
I want to be able to uncheck all the options in the start-up menu so
that along with the workgroup information, all the menu's are removed making the database even more secure. The problem with that is that I will not be
able to re-instate the menus to do changes should I need to. (Will I?)

With this in mind, is there any way I can create a transparent command
button hidden on one of the forms so that when clicked, then menu's will
re-appear?

Thanks all for your help?

Mark

Are these steps being taken in addition to using user-level security? If
so, you could have a tab on a form which only becomes visible if you log in
as a member of the admins group.

Fletcher

[Alan Webb]

Fletcher,
Build your own switchboard and login screen and check security on login. If
the login is allowed to get to the database window, let them in, otherwise,
load the user's menu to your switchboard.
"Fletcher Arnold" <fl****@home.com> wrote in message
news:c1**********@titan.btinternet.com...

"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:ygMZb.340$8N6.110@newsfe1-win...

Hi all,
I want to be able to uncheck all the options in the start-up menu so
that along with the workgroup information, all the menu's are removed making

the database even more secure. The problem with that is that I will not be able to re-instate the menus to do changes should I need to. (Will I?)

With this in mind, is there any way I can create a transparent command
button hidden on one of the forms so that when clicked, then menu's will
re-appear?

Thanks all for your help?

Mark

Are these steps being taken in addition to using user-level security? If
so, you could have a tab on a form which only becomes visible if you log

in as a member of the admins group.

Fletcher

[Fletcher Arnold]

"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:7dOZb.601$8N6.471@newsfe1-win...

Hi,
Yes, this is in addition to user level security.

Are you saying that it is possible to put all the menu's on a form which is only accessible to Admin users?

Yes. I find that it is sometimes better to make things entirely invisible
for standard users rather than making them visible but disabled. It is just
a question of psychology but it advertising the fact that there are features
there which the current user has no permissions for may make him or her feel
curious / snoopy / left out / whatever.

In this example, there is a form with 2 tabs on it. The second tab contains
controls intended only for db administrators so when the form is opened,
code checks to see if the current user is a member of the admins group and
if so makes the second page of the tab control visible. If the user is not
an administrator, there is no intimidating error message - the second tab
simply does not show up.

I hope you can adapt the general idea to meet your needs.

Fletcher

Private Function AmInAdmins() As Boolean

On Error GoTo Exit_Handler

If
Len(DBEngine.Workspaces(0).Groups("admins").Users( CurrentUser()).Name) > 0
Then
AmInAdmins = True
End If

Exit_Handler:
Exit Function

End Function
Private Sub Form_Open(Cancel As Integer)

On Error GoTo Err_Handler

If AmInAdmins() Then
ctlTab.Pages("pge2").Visible = True
Else
ctlTab.Pages("pge2").Visible = False
End If

Exit_Handler:
Exit Sub

Err_Handler:
MsgBox Err.Description, vbExclamation, "Error No: " & Err.Number
Resume Exit_Handler

End Sub

[Fletcher Arnold]

"Alan Webb" <kn*****@hotmail.com> wrote in message
news:_e***************@news.uswest.net...

Fletcher,
Build your own switchboard and login screen and check security on login. If the login is allowed to get to the database window, let them in, otherwise, load the user's menu to your switchboard.

Hi Alan
Did you see that I'm not the OP - that's Mark Reed, who seems to have
already decided on the built-in user-level security approach.
Regards,

Fletcher

[Roald Oines]

Fletcher Arnold (fl****@home.com) wrote:
: "Mark Reed" <ma*********@ntlworld.com> wrote in message
: news:7dOZb.601$8N6.471@newsfe1-win...
:> Hi,
:> Yes, this is in addition to user level security.
:>
:> Are you saying that it is possible to put all the menu's on a form
:> which is only accessible to Admin users?
:
:
: Yes. I find that it is sometimes better to make things entirely
: invisible for standard users rather than making them visible but
: disabled. It is just a question of psychology but it advertising the
: fact that there are features there which the current user has no
: permissions for may make him or her feel curious / snoopy / left out
: / whatever.
:
: In this example, there is a form with 2 tabs on it. The second tab
: contains controls intended only for db administrators so when the
: form is opened, code checks to see if the current user is a member of
: the admins group and if so makes the second page of the tab control
: visible. If the user is not an administrator, there is no
: intimidating error message - the second tab simply does not show up.
:
: I hope you can adapt the general idea to meet your needs.
:
: Fletcher
:
:
:
: Private Function AmInAdmins() As Boolean
:
: On Error GoTo Exit_Handler
:
: If
: Len(DBEngine.Workspaces(0).Groups("admins").Users( CurrentUser()).Name)
: > 0 Then
: AmInAdmins = True
: End If
:
: Exit_Handler:
: Exit Function
:
: End Function
:
:
: Private Sub Form_Open(Cancel As Integer)
:
: On Error GoTo Err_Handler
:
: If AmInAdmins() Then
: ctlTab.Pages("pge2").Visible = True
: Else
: ctlTab.Pages("pge2").Visible = False
: End If
:
: Exit_Handler:
: Exit Sub
:
: Err_Handler:
: MsgBox Err.Description, vbExclamation, "Error No: " & Err.Number
: Resume Exit_Handler
:
: End Sub

Thanks for posting this, Fletcher -- I've been wanting to do some
control hiding/unhiding based on a user's group for some time but
haven't been able to figure it out on my own.

--
http://rec-sport-golf.com/?rc=oinesroald
Please remove the under_scores if sending me mail.