Hope all is well, I am new to the forum and this is my first topic.
I just want to know if I can use MSIX for my builds as it is my understanding that the intension is to move all 32bit app installations that use exe and msi to MSIX in the future. I currently can build my app which works with an exe/msi using Advanced Installer. The installer needs to performs the following actions:
1. Places the files\folders in a standard folder that the user has full access like the Documents folder. Usually two folders are created within the Documents Folder, one that holds the programs (i.e accde files) and one that holds the templates (i.e accdb which is the backend and Ms Word files which are templates)
2. Creates the shortcuts and also places them on the desktop and the start menu etc. I use two shortcuts one to execute the accde files and one to point to the templates that the software used and can open. The user can copy a template and create their own work by starting with a template.
3. Registry keys are added to the Ms office products so that the folders that contain the accde files are trusted by the access runtime and can run the VBA code without any interruptions.
I also digitally sign my installation packages so that it can be trusted and my installations is a per user installation, hence why I can use the Documents folder.
One thing to note for those not familiar with Ms Access is that data is written to both accde/accdb files by the user or the program (e.g the user might input some date and the program writes data through VBA or when a linked table is populated with the data from the backend when connected).
All my attempts to create an MSIX package to achieve this has failed thus far, hence my question to the community to see if this is even possible.
Therefore, can I achieve the above through an MSIX installer or am I out of luck and have to stick with EXE and MSI as the installer for my builds ?