Menubar Gone -- How to Recover It?

[LarryP]

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?

 

[boblarson]

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

 

[LarryP]

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

 

[LarryP]

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!!!"

 

[Carol Grismore]

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

 

[Carol Grismore]

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?

 

[LarryP]

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!

 

[Rick Brandt]

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!

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.

 

[LarryP]

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.

 

[boblarson]

Rick:

Great thing to know and as Larry said, this is one for the toolbox.

Thanks!
--
Bob 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.
__________________________________