Link to home
Start Free TrialLog in
Avatar of phileoca
phileocaFlag for United States of America

asked on

Digital Signature Causes crash

Greetings,

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.

Check-for-updated-FE.mdb
Check-for-updated-FE---not-signe.mdb
Check-for-updated-FE-be.mdb
ASKER CERTIFIED SOLUTION
Avatar of John Mc Hale
John Mc Hale
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Just to test, I signed the Check-for-updated-FE.mdb you supplied with my own digital signature, and it did not crash, but grabbed the updated FE and ran it as expected!
The following discussion relates to signing MS Access 2003 ADE files with digital signature, with similar problems to yours, and were claimed to be solved by SP1 - I just went with SP3 as it was the most recent one, and cumulative:

http://www.secnewsgroups.net/access/t1005-opening-signed-ade-file-crashes-access-2003-runtimes.aspx

Good luck!
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of phileoca

ASKER

Thanks for the help!

Being a clean install I missed installing the service packs.

I applied the SP3 cumulative pack as well as access hot fix and it appears to be working like a charm!

Feel free to use the updater yourself.  :D