I have created Management Code Edine for Access 2003 using Visual Basic 2008 (VS Professional) and it works fine on my development machine. . It was created using the shared add-in template.
I used to set up the project to install ... and the .Net Framework was installed.
However, when I try to use, I get the following error in another PC:
Object 'comma' method 'connect' failed
The code which is failing is:
with COMAddIns ("MyAddin1.Connect") 'Make sure the COM add-in is loaded. .connect = True 'code has crashed here. Object Test addin and with is the article used (although this access was written for 2007)
Add is present in the archive but not connected Apart from this, it is not displayed in the list of com-add-ins installed via MS Access 2003 GUI.
I have tried to re-install Office 2003 (full install) and re-install the add-in. Some Points:
KB908002 is required for Office 2003 applications, not Office 2007 - I believe The net framework is the hotfixes / SP that installs it - there is no harm in installing it more than once - checks to ensure that what has been installed.
Office 2003 Primary Interop Assemblies are Required - If you have a Setup program, then you have the dependencies of the office that it lists (office.dll, Microsoft.Vbe.Interop.dll, etc.) And make sure PIA is installed
You can connect this PIA with product.xml in C: \ program files \ Microsoft Visual Studio 8 \ SDK \ v2.0 \ BootStrapper \ Packages \ Office2007PIA Build is included so that it appears in some other setup project (MS Download them from).
The installer should generate many registry entries, so the client needs to be installed, check in HKLM / SOFTWARE / Microsoft / Office / Access / AddIns that your adin is listed (I think it There will be, Excel Addins are listed under Office / Excel / AddIns (this is at this level, not under Office / 11.0 / ...)