I get a few emails each week from people asking about various VSTO related scenarios. I can usually point them to a related MSDN forum entry or blog post, or even (on a good day!) solve it for them myself.
Interestingly the question of Access add-ins has come up a few times lately, so I thought I’d make mention of it here.
Basically, the official position is that building Access Add-ins is NOT supported. There’s no template in Visual Studio for building any type of VSTO add-in for Access.
However, that’s not to say something can’t be done. Andrew Whitechapel wrote an excellent post back in February that covers the possibilities. Suffice to say, it is possible (in the sense that just about anything is possible) but – I repeat – is expressly NOT supported by Microsoft (his post explains why).
(Note: I haven’t tried this – I’m simply linking to it)
(Aside: If you are looking for the Access 2007 Developer Extensions (ADE) click here)
Thanks. I just uploaded Publisher 2007 VSTO templates to http://www.codeplex.com/VSTO
Thanks. I just uploaded Publisher 2007 VSTO templates to http://www.codeplex.com/VSTO
OK… I’m confused now. I’ve actually seen that VSTO add-in’s are not supported for Access in a few places… yet I’ve found this article that walks you through the creation of an COM Add-In for Access? Can you explain the difference as I understand it is not a template available from VS?
See link for article here: https://msdn.microsoft.com/en-us/library/Aa902693%28v=office.12%29.aspx?f=255&MSPPError=-2147217396
Also have been looking for more in-depth resources as to Add-In development for Microsoft Access as the ability isn’t new to Access… yet there really seems to be very little I can find in trying to learn it.