Recently, Arthur Fuller, a friend and colleague, had a mystery on his hands after updating an Access 2003 database to Access 2007. The 2003 version contained a custom toolbar that simply disappeared in Access 2007. He eventually found the custom toolbar hiding on the Add-Ins tab.
This 2007 behavior is as designed. When you open a legacy database that contains custom toolbars, there are two possibilities: If you replaced 2003's default menu bar with a custom bar object, 2007 will display the custom toolbar; when you open an .mdb file that maintains 2003's standard menu bar, 2007 displays custom toolbars on the Add-Ins tab. In this case, each group on 2007's Add-Ins tab corresponds to a custom toolbar from your .mdb file.
Custom toolbars must be visible in the 2003 database to appear on the Access 2007 Add-Ins tab. If an .mdb file doesn't contain a custom toolbar, Access 2007 hides the Add-Ins tab.
Related Topics:Data Management Big Data Analytics Data Centers Digital Transformation Cloud
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.