Open your legacy database in Access 2007.
Click the Microsoft Office Button, and then click Access Options.
In the Access Options dialog box, click Current Database.
Under Toolbar Options, clear the Allow Full Menus and Allow Built-in Toolbars check boxes.
Please let me know if you find a solution to the other problem! Thanks.
Under Toolbar Options, clear the Allow Full Menus and Allow Built-in Toolbars check boxes
I was not turning off "Allow Built-in Toolbars" also. That made it work for me.
Now my 2003 MDE front end runs with a similar look and menu style like it did in 2003.
... it gets rid of the existing menu with Database Tools, which is still needed.
Do you use this for development or do the end user use these options?
I would think you only need these options for development and not for the end users.
I have ever database split. Before I deploy the new front end as an MDE, I open the copy that is ready to be deployed and lock it down.
The development "master" copy still has all the menus, etc. turned on.
If your database is not split:
While developing you could turn on the Allow Full Menus and Allow Built-in Toolbars options. When done you would turn them off the options before letting the users back in.
If the end user do use these options you could add them to your own custom menu bar.
Thanks, I appreciate your interest in the how and why of what I'm doing. Most of what you are asking/suggesting has been discussed and rejected. I've been doing this for almost 20 years... yes, the database is split...no, it's not an mde because this particular client is not your usual end user. They are very good at creating their own queries, exporting to other Office products, even creating and linking new tables in SQL Server. So, I can't tie their hands.
The question still remains that I'd like to keep the standard Access menubar as well as automatically showing the new menu that I created for the additional functionality of this particular accdb.