Unhiding Tools option on Menu Bar

[PRath]

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.

 

[Keith Wilby]

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.

If Shift doesn't work then the AllowBypassKey property must be set to False.
Use whatever utility you used to do this to set it back to True.

More info here:

http://office.microsoft.com/en-us/access/HA012327171033.aspx

Keith.

 

[PRath]

Thanks Keith for the response.

However, i dont get this, can you please elaborate or explain in steps, if
thats ok?

 

[Keith Wilby]

Thanks Keith for the response.

However, i dont get this, can you please elaborate or explain in steps, if
thats ok?

I'm assuming that you've read the information provided by the link. Albert
Kallal has an excellent (and free) utility for enabling and disabling the
AllowBypassKey property. Have a look for "By Pass Shift Key Code" here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Keith.

 

[Chris O''Neill]

Yes, that's a neat little utility. One thing PRath should be aware of,
though, is that utiltiy does not set the Ddl flag, so it's more vulnerable to
someone else renabling the shift key bypass.

Regards, Chris

 

[Joan Wild]

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.

 

[Keith Wilby]

Yes, that's a neat little utility. One thing PRath should be aware of,
though, is that utiltiy does not set the Ddl flag, so it's more vulnerable
to
someone else renabling the shift key bypass.

I'm not familiar with the term "Ddl flag" Chris (perhaps you could elaborate
whilst I frantically Google) but I should add that it's possible to restrict
setting the AllowBypassKey property to the administrator account only.

Keith.

 

[Joan Wild]

I'm not familiar with the term "Ddl flag" Chris (perhaps you could
elaborate whilst I frantically Google) but I should add that it's possible
to restrict setting the AllowBypassKey property to the administrator
account only.

Keith.

That's what he's referring to. See
http://www.mvps.org/access/general/gen0040.htm

 

[Keith Wilby]

That's what he's referring to. See
http://www.mvps.org/access/general/gen0040.htm

Cheers Joan. Always something new to learn.

Keith.

 

[Keith Wilby]

Yes, that's a neat little utility. One thing PRath should be aware of,
though, is that utiltiy does not set the Ddl flag, so it's more vulnerable
to
someone else renabling the shift key bypass.

Now that I've read the code from the link that Joan provided, then slapped
my forehead, I've realised that I already use that code, so as long as you
*do* use the code then using Albert's utility does indeed restrict usage to
the Admins group. I just didn't recognise the phrase DDL

Regards,
Keith.

 

[Keith Wilby]

using Albert's utility does indeed restrict usage to the Admins group.

Just to clarify, you need to log on to Albert's utility using whilst joined
to your custom workgroup using your administrator account.

 

[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-

 

[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.