Rabu, 02 Mei 2012

[MS_AccessPros] Re: 2010 security again

 

Hi Phil

No problem! It's hard to keep up with all the posts here.

I put private sub in my startup form. If that is your login form put it there and call it from the Load event of that form.

call ShowHideRibbon(False)

False hides it; True shows it.

Bill

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