and reopening the database numerous times, that you get totally frustrated in trying to get the add-
in’s custom Ribbon to display (and its buttons to work). By contrast, Access add-ins that create
menu add-ins and property builders work just fine once they are installed, and so do Ribbons and
buttons created by VB 6 and Visual Studio add-ins.
When you need to put a button somewhere other than on the Add-Ins tab, and you don’t want to
fiddle with getting Ribbon buttons to work from Access add-ins, you can create a VB or Visual
Studio add-in — both work very well with Ribbons.
Another special consideration is running add-ins on Windows Vista — at present, Access add-ins
have problems with Vista security, while (at least if you have installed the hotfix mentioned in the
“Running Visual Studio 2005 in Windows Vista” sidebar — Visual Studio add-ins run fine in Vista.
Hopefully, v. 3 of VSTO should (at long last!) include an Access template, which should greatly
simplify the process of creating Shared add-ins for Access.
Part III Adding More Functionality to Office