Hi
I look after an Access 2003 application (mde) running on Access 2007 which uses a custom menu bar. A user has discovered that the menu bar can be dragged from its location to become floating, and that once floating it can be closed. Once closed I cant find a way to reopen it. I have tried reinstalling the mde to no avail so it must be something in Access itself. I have discovered that I can't edit the menu in 2007,
http://accessjunkie.com/faq_31.aspx, I have to use 2003 which we do not have on any office machine!!!
My questions are firstly how do I get the menu bar back on this one machine and second how do I stop it happening again, i.e. lock the menu. Do I have to go back to 2003?
Thanks for your help
The general rule for anything like this is always:
Create the MDE file in the same version of Access your users will be using.
So your basic options are:
- Create a new MDE for Access 2007 with Custom "Ribbons" that simulate the Access 2003 Menus
(Menus, as they were in Access 2003, do not exist in 2007)
http://msdn.microsoft.com/en-us/library/aa338202.aspx
(Not reccommended as creating custom ribbons is difficult for beginning developers.)
- Create a new MDE for Access 2007 without Custom "Ribbons", and just use the built in Ribbons. (Reccommended)
-Roll back to Access 2003 (Not reccommended)
Obviously, my personal opinions.
Lets see what some other experts have to say...
;-)
JeffCoachman