Avatar of Petrobras
Petrobras
Flag for United States of America asked on

Reactivate Tools bar

Hello experts,

I thought I would try to get a little fancy with hiding things to prevent users from accessing the tools bar and of course it backfired.  I went to startup then unchecked:

- Allow Full Menus
- Allow Toolbar/Menu Changes

I had read other posts and know that you can reactivate the Toolbar menu by holding down shift and then opening the db.  This does not work for me.  I can open up other mde's and have access to tools bar.  I also tried to right click, left click, center click up at the top of the menu bar for properties but no type of properties appeared.  

there was a question about this here but no definite answer:
https://www.experts-exchange.com/Databases/MS_Access/Q_21430243.html?query=reactivate+tools&topics=39

Any ideas on why I get this?  Maybe it is because I am working on a work computer that has high security?  
Microsoft Access

Avatar of undefined
Last Comment
Petrobras

8/22/2022 - Mon
mbizup

Petrobras,

Try running these two lines in VBA:

Application.CurrentProject.Properties("AllowShortcutMenus") = true
Application.CurrentProject.Properties("AllowToolbarChanges") = true

You may need to restart the application for these to take effect
mbizup

Sorry... I misread "FullMenus".  To reset full menus:

Application.CurrentProject.Properties("AllowFullMenus") = true

Check out the VBA help info on setting startup properties.  You can alter any of those startup  properties in a similar manner.
ASKER CERTIFIED SOLUTION
mbizup

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
jjafferr


Another way of doing it,
make a new mdb where the Tools bar is shown,
then import the objects (Forms, tables, queries, reports,modules) from the older mdb

jaffer
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Petrobras

ASKER
morning...

mbizup:  your answer worked just fine.  I am still a little confused as to why I was not able to bypass the restriction on the toolbar.  

jjaffer:  thanks for the info.  I had thought of doing that but thought of it as a last resort.  

Capricorn:  
<holding down shift and then opening the db.  This does not work for me>
What I mean is I single click the app and then hold down shift then double click the app.  
'you able to bypass the startup form or Not?  
>I was able to bypass the start up form.  
I see now what I did wrong.  I only though you had to hold down the shift key and double click the app and then let go of the shift however you need to continue holding it down until you see the db window.  After doing this, the shift key did restore full menus.  

Thanks for the info


Petrobras

ASKER
One other question though:
I would think it would be possible to bypass a lot of security measures implemented in the app by way of reimporting everything in a new db.  Do you follow me?  Is this correct in assuming this is a cure all for most security measures such as disabling the toolsbar and other measures.  Maybe even a log in screen could be bypassed doing this way?

thanks
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Petrobras

ASKER
Hi jjafferr, so in effect, by doing this import into a new db some of the restrictions placed in the old db would not carry over to the new db?  This seems too easy to bypass...??

thank you
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
jjafferr

Yes, but it all depends on the permissions you gave in your original mdb, and if it had a password,
mbizup

>I am still a little confused as to why I was not able to bypass the restriction on the toolbar.  
Petrobras,

Do you mean by using the Shift key?  The shift-key bypass allows you to display the database window, if that startup option is unchecked.  As far as I know, it does not override other startup options such as tollbars, shortcut menus, etc.
Petrobras

ASKER
mbizup, sorry but I had a post that was kind of buried explaining that I know what I did:
here it is Date: 09/13/2006 08:23AM CDT:
I see now what I did wrong.  I only though you had to hold down the shift key and double click the app and then let go of the shift however you need to continue holding it down until you see the db window.  After doing this, the shift key did restore full menus.

'it does not override other startup options such as tollbars, shortcut menus, etc.
>Apparently, it does

thanks!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes