Access AddIn question??

[jdraw]

I have an Access Addin that was registered/installed with UsysRegInfo. Using Database Tools I added the addin to a working database. My question is "How can I remove the Addin (or linkage) from my working database without removing the AddIn from Ms Access??

 

[Josef P.]

In my opinion, this is not possible - at least not in a stable way.

The entry with UsysRegInfo is a general menu entry for Access, without any special option to bind it to specific Access files.

If the menu entry should not be visible for a specific Access file (application), you could use code to remove the entry in the registry and add it again when exiting. However, it is then generally not available during this time.
There is also a risk that reactivation may not go through due to a crash.

 

[jdraw]

Thank you Josef for responding. When using Database Tools and attaching/linking the Addin(Access not COM) to the working database, what exactly is the linkage that is established? Do you have any code suggestions for removing the entry in the registry and replacing it?
I am not familiar in any detail with AddIn (logic/structure) -- I have built 1 (3 versions of a basic utility) -- but no experience with the details of how the "pieces" are connected. Any help would be appreciated.

Note:
I tried creating a blank database and copying only the objects from the "working database". However, that newly created database also contains linkage to the AddIn. So that's 1 approach that didn't work!

 

[Josef P.]

Access add-ins are not loaded when Access is started. It is only loaded when it is called up via the usual entry in the add-in menu or from another location.
See in registry: Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Menu Add-Ins

What do you want to use your add-in for?
If it should only be available for certain applications, you could call it from the application without registering for the add-in menu.

Application.Run "PathToAddIn\AddInFileNameWithoutACCDA.ProcedureName"

 

[jdraw]

Thanks Josef. It seemed that the addin was being linked to the working database. I loaded the addin via Database Tools and selected the specific addin. With a bit of testing I see that it was removed/delinked when I closed the database and shut down Access.