RE: Digitally signing an Access database .mde or .mdb

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Eric Butts [MSFT] (ebutts_at_online.microsoft.com)
Date: 07/07/04


Date: Wed, 07 Jul 2004 00:48:31 GMT

Hi John,

Check the Microsoft Access help topic "Digital Signature" for details.
Here are some steps you can follow:

To add a Digital Signature to an application, follow these steps:
Start Access 2003 and open the database you are using for your run-time
application.
On the Tools menu, point to Macro, and then click Visual Basic Editor.
In the Project Explorer, select the project you want to sign.
On the Tools menu, click Digital Signature.
In the Digital Signature dialog box, click Choose.
In the Select Certificate dialog box, select one of the available
certificates, and then click OK.
In the Digital Signature dialog box, click OK.
Close the Visual Basic Editor and then close Access.

To trust the Digital Signature, if it is not automatically trusted, follow
these steps:
Start Access 2003 and open the database you are using for your run-time
application.
If you are prompted with the dialog box "Security Warning: Unsafe
expressions are not blocked", click Yes.
In the next Security Warning dialog, click Details.
In the Digital Signature Details dialog box, click View Certificate.
In the Certificate dialog box, click the Certification Path tab.
Select the Certification path that has the Red X, click View Certificate.
In the Certificate dialog box, click Install Certificate.
In the Certificate Import Wizard, click Next.
Leave the option to Automatically select the certificate store based on the
type of certificate.
Click Next.
Click Finish.
Click Yes when prompted to add the certificate to the Root Store.
Click OK four times until you are back at the Security Warning dialog box.
Click Cancel or Open in the Security Warning dialog box.
The next time you open the database, you will have the option to "Always
trust files from this publisher and open them automatically".

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.

Regards,

Eric Butts
Microsoft Access Support
ebutts@online.microsoft.com
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "John Buckett" <anonymous@discussions.microsoft.com>
| Sender: "John Buckett" <anonymous@discussions.microsoft.com>
| Subject: Digitally signing an Access database .mde or .mdb
| Date: Fri, 2 Jul 2004 08:51:30 -0700
| Lines: 3
| Message-ID: <2545101c4604c$714b2e70$a401280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcRgTHFLieMgJzFWTN+lkx2lzgqfsQ==
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:11914
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.security
|
| I've been over the the artical "Frequently asked
| questions about Access security warnings" and cannot find
| a way to digitally sign an Access database mde or a mdb.
|



Relevant Pages

  • RE: Security Warnings pop up in Run Time distribution Access 2003
    ... in Medium security by default and you cannot modify Macro Security settings. ... Microsoft Root Certificate Program Members ... The developer can also use a signature created with Microsoft Certificate ... Steps to Add the Digital Signature to the Application ...
    (microsoft.public.access.security)
  • Re: Digitally signing an Access database .mde or .mdb
    ... How do I get all the office programs on all the computers to trust ... >On the Tools menu, click Digital Signature. ... >In the Digital Signature Details dialog box, click View Certificate. ... >Click OK four times until you are back at the Security Warning dialog box. ...
    (microsoft.public.access.security)
  • Re: copy digital signature (certifice) to second computer
    ... You can use Microsoft makecert.exe to make a certificate with an exportable ... > How can I copy my digital signature to my laptop and sign VBA code with ...
    (microsoft.public.excel.programming)
  • RE: receive an SSL Certificate error message when you view public
    ... The certificate received from the remote server does not contain the ... > folder from OWA or outlook 2003? ... > Microsoft CSS Online Newsgroup Support ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: ssl certificate error on public folders
    ... click the Server Certificate button. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... Restart the IIS Admin service in the services mmc. ...
    (microsoft.public.windows.server.sbs)