 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Setup / Configuration / December 2007Menubar Gone -- How to Recover It?
One of the users of my databases also has another .mdb with custom menus and toolbars. Best I can figure out, when she launched that database it hid the standard menubar, but now it's hidden in MY databases too. I've had her try Rightclick-Customize-Menubar-Reset, no luck. Also tried Application.Menubar = "" via the VBA Immediate window, again no luck. Short of having her completely uninstall and reinstall MSOffice/MSAccess, any suggestions about (1) getting her menubar back and (2) preventing it from vanishing again every time she launches that other database? Have you tried holding the SHIFT key down while opening your database? If you do that you should be able to get to the TOOLS > STARTUP to reset the settings.  SignatureBob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ If my post was helpful to you, please rate the post. > One of the users of my databases also has another .mdb with custom menus and > toolbars. Best I can figure out, when she launched that database it hid the [quoted text clipped - 4 lines] > (1) getting her menubar back and (2) preventing it from vanishing again every > time she launches that other database? Never even thought of that (slap forehead once!), since it's not MY startup settings that turn off the menu bar. Will stop by her desk some time today and see if that works. Still leaves open the question of how to keep it from getting turned off again every time she runs that other database.... > Have you tried holding the SHIFT key down while opening your database? If > you do that you should be able to get to the TOOLS > STARTUP to reset the [quoted text clipped - 8 lines] > > (1) getting her menubar back and (2) preventing it from vanishing again every > > time she launches that other database? Unfortunately, no joy. Tried to open several databases while holding down Shift, and even created a new blank database and did likewise. All of them opened without the menu bar. I did determine that if *I* log onto her computer with *MY* ID and create a database, it has the menu bar, so there is apparently some pesky setting out in the registry somewhere or in her user profile that says when SHE launches a database, no menu bar, please. I had her completely uninstall and reinstall Office/Access hoping it would take her back to default settings, but no luck, the gremlin is still lurking out there. So I'm back to "Hel-l-lllp!!!" > Have you tried holding the SHIFT key down while opening your database? If > you do that you should be able to get to the TOOLS > STARTUP to reset the [quoted text clipped - 8 lines] > > (1) getting her menubar back and (2) preventing it from vanishing again every > > time she launches that other database? LarryP -- I'll be watching posts to this problem with interest. I am having the same problem, but with an office of about 70 people! -- Carol > Unfortunately, no joy. Tried to open several databases while holding down > Shift, and even created a new blank database and did likewise. All of them [quoted text clipped - 21 lines] > > > (1) getting her menubar back and (2) preventing it from vanishing again every > > > time she launches that other database? I had a thought -- something about administrative rights on the computer -- could the user's permission level be so low that the default settings can't be restored after having been taken away? SignatureCarol > Unfortunately, no joy. Tried to open several databases while holding down > Shift, and even created a new blank database and did likewise. All of them [quoted text clipped - 21 lines] > > > (1) getting her menubar back and (2) preventing it from vanishing again every > > > time she launches that other database? At least in the case of my user, no; she has full admin rights. But I just solved her problem as follows: since she's an administrator, I had her make ME an administrator too. Then I logged on and renamed her user profile under Documents and Settings, after which I logged off and had her log back on. Windows couldn't find her profile, so it created a new one, and presto, the menu bar in Access was back. I then copied all the files from her old profile, one folder at a time, over into her new profile, checking between each copy to see if the menu bar was still showing, and it was in all cases. So the problem had to do with her old profile and, I assume, the Registry entries related to her old profile (but not with any specific file stored under her old profile). As soon as she had a new profile that relationship was evidently broken and the menu bar came back. A bit tedious, and if it turns out you have to do it on 70 computers, you have my sympathy! > I had a thought -- something about administrative rights on the computer -- > could the user's permission level be so low that the default settings can't [quoted text clipped - 25 lines] > > > > (1) getting her menubar back and (2) preventing it from vanishing again every > > > > time she launches that other database? > At least in the case of my user, no; she has full admin rights. But > I just solved her problem as follows: since she's an administrator, [quoted text clipped - 11 lines] > tedious, and if it turns out you have to do it on 70 computers, you > have my sympathy! Customizations to standard menus and toolbars (show/hide, position, etc.) is stored in the system registry. All you needed to do was clear the registry settings at... HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Access\Settings\CommandBars The above is for Access 97, but other than the "8.0" your version should have the same registry folder in a similar location. Clearing that entire folder would reset all command bars to their default settings. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Rick, you are Aces! I avoid the Registry like the plague unless I have very specific instructions, but yours are exactly that and I'll save them forever. Thanks much. > > At least in the case of my user, no; she has full admin rights. But > > I just solved her problem as follows: since she's an administrator, [quoted text clipped - 21 lines] > the same registry folder in a similar location. Clearing that entire folder > would reset all command bars to their default settings. Rick: Great thing to know and as Larry said, this is one for the toolbox. Thanks! SignatureBob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com If my post was helpful to you, please rate the post. __________________________________ > > At least in the case of my user, no; she has full admin rights. But > > I just solved her problem as follows: since she's an administrator, [quoted text clipped - 21 lines] > the same registry folder in a similar location. Clearing that entire folder > would reset all command bars to their default settings. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.