How to remove Digital Signitures

[JohnC]

I have an 2000 database that was created in Access 2003 that has been signed
and now I want to remove the signiture so that the Access 2000 user(s) can
review the code.

I followed the instructions in http://support.microsoft.com/kb/823225/en-us
and the only way that I can review code is when the code has been sighed
otherwise i get message that the Project is unviewable

Any assistance would be appreciated

 

[Scott McDaniel]

I have an 2000 database that was created in Access 2003 that has been signed
and now I want to remove the signiture so that the Access 2000 user(s) can
review the code.

I followed the instructions in http://support.microsoft.com/kb/823225/en-us
and the only way that I can review code is when the code has been sighed
otherwise i get message that the Project is unviewable

You must remove the signature from each file ... so if you distribute your file to me, and you want me to be able to
view the code, then you'd need to either (a) instruct me how to remove the sig on my machine or (b) remove the sig from
your file, and send me that file.

Any assistance would be appreciated

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[JohnC]

You must remove the signature from each file ... so if you distribute your file to me, and you want me to be able to
view the code, then you'd need to either (a) instruct me how to remove the sig on my machine or (b) remove the sig from
your file, and send me that file.


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

I only have one file and I am attempting to remove the signature. At this
point forget shipping the file, I just want to remove the signature and when
I follow the steps in the KB i get the Project is unviewable. I can open the
module when I put the signature back on.

I tried taking the signature off and then converting the code to 2003 before
closing access and that really upset Access

 

[Scott McDaniel]

I only have one file and I am attempting to remove the signature. At this
point forget shipping the file, I just want to remove the signature and when
I follow the steps in the KB i get the Project is unviewable. I can open the
module when I put the signature back on.

I tried taking the signature off and then converting the code to 2003 before
closing access and that really upset Access

I don't really follow ... is this your digital certificate? Did you build the database?

If it's your's, then the steps are pretty simple:

--Open the file that contains the Visual Basic for Applications (VBA) project from which you want to remove the
signature.
--On the Tools menu, point to Macro, and then click Visual Basic Editor.
--In the Project Explorer, select the project from which you want to remove the signature.
--On the Tools menu, click Digital Signature.
--Click Remove.

from here: http://office.microsoft.com/en-us/access/HP010446141033.aspx

Further, if you can review the code when the project is signed, then I don't see the problem ... with a digitally signed
project, you would NOT want to edit any code (since you'd then void the signature) ... instead, you'd edit the code,
then re-sign the file before distributing ...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[JohnC]

THese are the steps that I have attempted and they make complete sense to me,
however I get the project is unviewable.
The issue is that I created the code but the code belongs to the client that
is still using Access 2000. The signiture is a local one that is on my
computer.
The database causes an error when compacting but it does compact correctly.

 

[Scott McDaniel]

THese are the steps that I have attempted and they make complete sense to me,
however I get the project is unviewable.
The issue is that I created the code but the code belongs to the client that
is still using Access 2000. The signiture is a local one that is on my
computer.
The database causes an error when compacting but it does compact correctly.

What's the error?

Is this a commercial certificate, or one that you built using the selfcert utility?

You mention that you an actually view the project ... if so, then just export everything from that project to a new
container ...

Also, if you've used an Access 2003-specific code (like the Printers object, for example) then your client may not be
able to successfully view the code.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[JohnC]

It a certificatebuilt using the selfcert utility

I created a new database and imported all of the objects and it opens
without a certificate.

I guess when all else fails.

 

[Scott McDaniel]

It a certificatebuilt using the selfcert utility

I created a new database and imported all of the objects and it opens
without a certificate.

Great. I'd strongly encourage you, however, to purchase a certificate if you're going to develop Access apps
professionally (or develop in any language, for that matter). A self-cert is only as good as the machine it's built on,
and in many cases won't even function on the enduser machine.

I guess when all else fails.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com