Re: Unhiding Tools option on Menu Bar

23 Nov 2008 4:37 AM

adam

Dear Access Security Expert,

I came across this same situation when I try to Access the hidden Tools menu
by holding down the shift key long enough to open the database that is linked
to a secured System.mdw file.

I can see the Tools menus and other menus that were intentionally hidden.
However, I can not SAVE any changes I just made to those options setting,
e.g. uncheck hide/display partial menu, etc.

That is although I go through the backdoor to access options under Tools
menu, however, I can not save the changes I just made due to the linked
System.mdw file.
I didn't go through the login process.

My question is how I could make secured MS Access database display all menus
as usual. Again, shift key can only allow me to view and uncheck/check
options, BUT it will not save my changes... HELP!!!

-adam-

Show quoteHide quote

"Joan Wild" wrote:

> Since you're the one who set the startup options, I'm assuming you didn't
> disable the shiftkey bypass. Perhaps you aren't holding the shift key down
> long enough - keep holding it down until the db opens.
>
> --
> Joan Wild
> Microsoft Access MVP
> "PRath" <PR***@discussions.microsoft.com> wrote in message
> news:944A6896-D836-4D28-AF58-8B5E6C7B361B@microsoft.com...
> >I disabled the drop down menus on my database for security purposes via
> > Tools, Startup and unchecked Allow Full Menus. How do I unhide the menu
> > options?
> >
> > I tried the Shift option and the F11 option, both do not work, i m using
> > Access 2003 and my database open a form by default....can the form thing
> > be
> > the issue?
> >
> > Please repond. Thanks.
> >
>
>

23 Nov 2008 5:42 PM

Joan Wild

It sounds to me as though you are opening the secure mdb using the standard
system.mdw that ships with Access.

Did you set up security to allow using the mdb with this mdw? (i.e. you gave
permissions to the Users Group)

If not, then your database is not secured. You shouldn't be able to even
open the mdb unless you are using the correct secure mdw.

You said "I didn't go through the login process" - so you're not using the
secure mdw.

If you want to see the full menus, you need to use your desktop shortcut
(with the /wrkgrp switch). Hold down the shiftkey after you supply your
username/password, and continue to hold it down until the mdb is open.

--
Joan Wild
Microsoft Access MVP

Show quoteHide quote

"adam" <a***@discussions.microsoft.com> wrote in message
news:B7E622A2-6DD2-4ED2-9BDB-2684C571AC3D@microsoft.com...
> Dear Access Security Expert,
>
> I came across this same situation when I try to Access the hidden Tools
> menu
> by holding down the shift key long enough to open the database that is
> linked
> to a secured System.mdw file.
>
> I can see the Tools menus and other menus that were intentionally hidden.
> However, I can not SAVE any changes I just made to those options setting,
> e.g. uncheck hide/display partial menu, etc.
>
> That is although I go through the backdoor to access options under Tools
> menu, however, I can not save the changes I just made due to the linked
> System.mdw file.
> I didn't go through the login process.
>
> My question is how I could make secured MS Access database display all
> menus
> as usual. Again, shift key can only allow me to view and uncheck/check
> options, BUT it will not save my changes... HELP!!!
>
> -adam-
>
>
> "Joan Wild" wrote:
>
>> Since you're the one who set the startup options, I'm assuming you didn't
>> disable the shiftkey bypass. Perhaps you aren't holding the shift key
>> down
>> long enough - keep holding it down until the db opens.
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>> "PRath" <PR***@discussions.microsoft.com> wrote in message
>> news:944A6896-D836-4D28-AF58-8B5E6C7B361B@microsoft.com...
>> >I disabled the drop down menus on my database for security purposes via
>> > Tools, Startup and unchecked Allow Full Menus. How do I unhide the
>> > menu
>> > options?
>> >
>> > I tried the Shift option and the F11 option, both do not work, i m
>> > using
>> > Access 2003 and my database open a form by default....can the form
>> > thing
>> > be
>> > the issue?
>> >
>> > Please repond. Thanks.
>> >
>>
>>