[MS_AccessPros] Re: 2010 security again

 

Phil

You have to hide the ribbon to prevent users from getting to that tab.

Call this Sub with the argument set to False.

Private Sub ShowHideRibbon(bolShowRibbon As Boolean)
'Purpose : Shows or hides Ribbon depending on Boolean argument.
' Can be run in versions older than 2007 with no ill effects.
'DateTime : 4/11/2011 08:03
'Author : Bill Mosca
'Requires :
On Error Resume Next

'Hide or restore ribbon in versions 2007+.
If bolShowRibbon = True Then
DoCmd.ShowToolbar "Ribbon", acToolbarYes
Else: DoCmd.ShowToolbar "Ribbon", acToolbarNo
End If

End Sub

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, "pdk444444" <pdk444444@...> wrote:
>
> I have gone through setting up username and password security in a 2010 environment and I am pleased now with the restrictions I have been able to put on my users.
>
> However, It seems that even the most restricted user can get to the Access options (via the File tab) and can change these options - which could wreak havoc on the way access is used.
>
> Am I right about this? and if so is there a way I can prevent this?
>
> cheers
>
> Phil
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 3
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___