Add a digital certificate to an Access 2000 project

I have created an in house digital certicate with selfcert.exe.  How do I add it to my Access 2000 project so the computers in the network using Access 2003 can use it?  I went to VBA tools (in Access 2000)  but did not find "Digital Signature" there as stated in http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=194.  

Note: I do not need to know how to accept the certificate in the 2003 computers; just how to add the certificate the the 200 project.

TIA
LVL 39
thenelsonAsked:
Who is Participating?
 
miqrogrooveConnect With a Mentor Commented:
That sounds like a confirmation to me.  I'll second that.
0
 
miqrogrooveCommented:
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.
0
 
thenelsonAuthor Commented:
"Digital Signature" does not exit in the Tools menu (or any other menu) in Access VBA 2000.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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

/gustav
0
 
thenelsonAuthor Commented:
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?
0
 
Gustav BrockCIOCommented:
That triggered something. Have a look here:

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

/gustav
0
 
miqrogrooveCommented:
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
0
 
thenelsonAuthor Commented:
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

0
 
miqrogrooveCommented:
"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
0
 
thenelsonAuthor Commented:
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.
0
 
miqrogrooveCommented:
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.
0
 
thenelsonAuthor Commented:
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.
0
 
Gustav BrockCIOCommented:
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
0
 
Gustav BrockConnect With a Mentor CIOCommented:
Hold it a little please, I'll double check ...

/gustav
0
 
thenelsonAuthor Commented:
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
0
 
Gustav BrockCIOCommented:
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
0
All Courses

From novice to tech pro — start learning today.