Solved Create a function to save my Add_IN file.

[Superpat]

Hello,
When I open my VBA editor from an accdb file and when I have a link with an accda add-in file, if I modify my add-in file, I can't save it, even if I close the accdb file first.
I have to copy/paste, close everything and reopen the add-in to be able to save !
Do you have a function or a trick ?
Have a nice day!

 

[AHeyne]

Unfortunately, this is the case, even if, for example, an ACCDB is referenced in the current project.
There is nothing you can do about it.

 

[isladogs]

There should never be a reason to edit an add-in file from the host app.

Add-ins are designed so that they can only be edited by opening the original file directly.
In addition, the designated add-ins folder C:\Users\UserName\AppData\Roaming\Microsoft\AddIns is protected.

These measures are both designed to ensure the functionality of the add-in isn't compromised by its use in a host app

Similar behaviour exists if you open an Access app as a library file. You can use the code from the host app but cannot save any changes to it.

 

[Superpat]

Thanks for your answers, so I'll continue with copy/paste.
I'll switch to solved.

 

[Josef P.]

Note: Copy file to %appdata%\Microsoft\Add-Ins\...

I usually use a VB-Script to quickly install/update an add-in in the add-in folder.
Example: https://github.com/AccessCodeLib/FilterFormWizard/blob/main/access-add-in/Install.vbs

Because I like the variant of msaccess-vcs-addin to install the add-in by starting the add-in itself, I created a simplified example based on this principle:

GitHub - AccessCodeLib/ACLibAccessAddInBuilder

Contribute to AccessCodeLib/ACLibAccessAddInBuilder development by creating an account on GitHub.

github.com

 

[Superpat]

Note: Copy file to %appdata%\Microsoft\Add-Ins\...

I usually use a VB-Script to quickly install/update an add-in in the add-in folder.
Example: https://github.com/AccessCodeLib/FilterFormWizard/blob/main/access-add-in/Install.vbs

Because I like the variant of msaccess-vcs-addin to install the add-in by starting the add-in itself, I created a simplified example based on this principle:

GitHub - AccessCodeLib/ACLibAccessAddInBuilder

Contribute to AccessCodeLib/ACLibAccessAddInBuilder development by creating an account on GitHub.

github.com

Thank you, a Titan's work