Add a digital certificate to an Access 2000 project

I usually find it by hitting Alt+F11, then going to the last option in the Tools menu, which is "Digital Signature".  I'm running Access 2003 now.

"Digital Signature" does not exit in the Tools menu (or any other menu) in Access VBA 2000.

As far as I know you need A2003 to do this.

/gustav

Strange since I got selfcert.exe from my A2000 disks.  If that is the case, do you know if I can add the cert in A2003 then continue creating and compliling code and creating the mde in A2000 without losing the cert?

That triggered something. Have a look here:

http://www.elementkjournals.com/premier/showArticle.asp?aid=3021

/gustav

thenelson,

Access 2000 definitely has the ability to both sign and accept macros with digital certificates.  Microsoft offers this point on their website:

"For more information about digital certificates and signatures, click Microsoft Product Help on the Help menu, type How do I digitally sign my project in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned."

Hope that helps,
-- Miqro

Gustav,
Yep, that's what I did to get a copy of selfcert.exe.  I then ran selfcert.exe.  Now I would like to know how to get A2000 to accept the cert.

Miqro,
I cut and pasted "How do I digitally sign my project" into the answer wizard and got nothing useful (don't you just love MS support?.)  If you get something useful, can you send it to me?

Thanks

Nelson

"NOTE: The SelfCert.exe program is not part of the standard installation of Microsoft Office. If you need to install the SelfCert.exe program, rerun Setup for Office CD1 and click Add or Remove Features. Click the plus sign (+) next to Office Tools; click Digital Signature for VBA Projects and then click Run from My Computer. Click Update Now."

My guess is that if you obtained selfcert.exe directly from disc instead using the installer, then the related signing features in the Project Explorer were not installed.

Try reinstalling the project signing component, that should do it.

-- Miqro

Miqro,

This is how I got selfcert.exe: Setup for Office CD1 and click Add or Remove Features. Click the plus sign (+) next to Office Tools; click Digital Signature for VBA Projects and then click Run from My Computer. Click Update Now.

I did not see anything in the Project Explorer related to signing projects.  I quess I could check setup again.

Is this option available in the VBA Editor from Word or Excel?  If yes, then it is possible Office 2000 did not support it in Access(?)  If not, then I would suggest removing all of the VBA and digital signature components and reinstalling them.  It might not hurt to just reinstall Office while you're at it.  If I had a copy of Access 2000 lying around I would check it out for you, but I don't.  Sorry.

In 2000 Word and Excel have it; Access does not.  I guess your guess is right that it is not supported in A2000.  I'll check for an add-in.

I have now search all over but found nothing. The closest is how to sign VBA code in _Office_ without mentioning Access. A couple of hits claims this is not possible neither with Access 2000 nor Access 2002/XP. My Excel 2000 offers to sign VBA code so I'll have to believe that the feature is installed correctly.

So until further I think I'll stick with my original message:

> As far as I know you need A2003 to do this.

/gustav

Ok, I found the reference from the horses mouth that Access 2000 does not support digital signing: http://support.microsoft.com/default.aspx?scid=kb;en-us;816895&Product=ofw2k.

Not the anwer I wanted but I'm going to split the points between migrogroove and cactur_data for hanging in there with me.  Thanks guys.

Nelson

That link relates to Microsoft Office 2000 Standard Edition.

However, I cannot get any further confirmation, so I think we'll have to accept as a fact that the feature to sign projects is missing in Access 2000.
 
/gustav