I have a little launcher application (1 form, 1 module) that simply checks if my FE needs and update, downloads if necessary, then launches the FE.
I am using my 2003 windows server Certification Authority to do digital certificates for Code Signing on my domain. These are not LOCAL digital certificates, but are domain certs.
When i leave the application UNSIGNED, it works fine.
When I digitally sign the application, it crashes with the error message :
"Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience."
It also will crash when I try to Shift-open.
Another application I developed DOES NOT crash with the same digital signature.
Also, the launcher does not fail when launched on my development station. Only on other workstations (and yes, all other work stations have the same problem)
I've attached the backend file and 2 front end files.
The way it works:
Form opens sets form values, calls code, checks if update is necessary, launches database (see tables for database name and path), closes launcher application.
I do not know why the digital signature is causing it to crash. It works fine without the cert, but i'd rather the user not have to press "Open" every time they open the program. (the file may not be safe if it contains code that was intended to harm your computer) and i'd prefer to not change the macro security level.