We have over 20 different clients operating on our systems here. Our System Architect and management want to change the Security level in Microsoft Office to Medium meaning when a user opens an access client they will get the old “this database isn’t signed” prompt. To suppress this, Our company has invested in a verisign signature so we can digitally sign them all before they are deployed.
Our problem is with one of these 20. It signs fine but when it’s opened on a users computer it becomes ‘unsigned’ we have looked into this and it’s not to dissimilar from another client that has no problems at all. When the mdb is opened we do find that an error message comes up saying the file couldn’t be found (This has occurred with another 3 clients as well). To work around this we have put the ms access exe ref in the short cut like so;
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE” "C:\Program Files\Access Clients\contracts\contractsclient.mdb"
When the client in question launches a form is set to open. There is an on open event and an on current event but nothing too special in the code and it contains no macros. But it would seem that the signature breakage occurs sometime before the form opens.
Our problem is with one of these 20. It signs fine but when it’s opened on a users computer it becomes ‘unsigned’ we have looked into this and it’s not to dissimilar from another client that has no problems at all. When the mdb is opened we do find that an error message comes up saying the file couldn’t be found (This has occurred with another 3 clients as well). To work around this we have put the ms access exe ref in the short cut like so;
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE” "C:\Program Files\Access Clients\contracts\contractsclient.mdb"
When the client in question launches a form is set to open. There is an on open event and an on current event but nothing too special in the code and it contains no macros. But it would seem that the signature breakage occurs sometime before the form opens.