Link to home
Start Free TrialLog in
Avatar of Petrobras
PetrobrasFlag 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/questions/21430243/Restoring-Access-2003-Startup-Options.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?  
Avatar of mbizup
mbizup
Flag of Kazakhstan image

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
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
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 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


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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Yes, but it all depends on the permissions you gave in your original mdb, and if it had a password,
>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.
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!