Rabu, 02 Mei 2012

[MS_AccessPros] Re: 2010 security again

 


Hi Bill

Many apologies for not thanking you for this response before now - I have only just found it !!!

I will look into this - I am not sure where I create this private sub and where I call it from ?

The ribbon appears as soon as the user enters their username and password so I want to stop them getting to the file options straight away.

I'm a bit confused

Phil

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> 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
> >
>

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar