I have developed a database application in Access 2007 for a client. The client needs to be able to distribute this application in an install package to end users (paying customers) who may or may not have Access 2007 installed. I've been using the Package Solution Wizard and it suits my needs fine, except for one issue. We can't have the Access security alerts pop-up every time the user starts the application.
A signed certificate seemed the obvious solution; however, the ability to sign and distribute code in Access 2007 seems very limited (quite surprising to me). I tried the "Package and Sign", but that just seems to create signed self-extracting zip file, which is entirely insufficient for my needs, and even when I click "Always trust this publisher", I still get the security alerts when running the extracted database.
It seems that I probably have no choice but to ditch the Package Solution Wizard entirely and use a third-party installation wizard. I have limited experience with Inno Setup, but I've only done pretty plain-vanilla install scripts with it.
I need a packaging and distribution option that will allow the following:
Sign the application files so that when a user clicks "always trust", they are never prompted again when they start the application.
Set a desktop icon and start menu short cut.
Distribute multiple files in the package.
Easy to use installation wizard.
Include a EULA that must be agreed to, to install the application.