Show trust by adding a digital signature

You can show that you believe a database is safe and that its content can be trusted by adding a digital signature to the database. A digital signature confirms that any macros, code modules, and other executable components in the database originated with the signer and that no one has altered them since the database was signed. This helps people who use the database decide whether to trust it and its content. Think of a security certificate as a pen that you use to digitally sign things, or a wax seal that only you can apply. To add a digital signature, you can use a commercial security certificate, or you can create your own. The process that you use to digitally sign a database depends on the database version you are using.

In this article

Get a security certificate

Digitally sign an Access 2007 or Access 2010 database

Digitally sign an Access 2013 or later database

Get a security certificate

There are two types of security certificates: commercial and self-signed.

Obtain a commercial security certificate

If you want to digitally sign a database and then distribute that database commercially, you should obtain a commercial security certificate from a commercial certificate authority (CA). Certificate authorities do background checks to verify that the people who create content (such as databases) are reputable. For more information, see Find digital ID or digital signature services.

Create a self-signed certificate

If you want to use a database for personal or limited workgroup scenarios for use within your own organization, you can create a digital certificate by using the SelfCert tool included with Microsoft Office.

  1. Browse to the folder that contains your Microsoft Office program files.

    You'll need to locate the executable file, SelfCert.exe, and the location can vary based on various conditions such as if you're using a 32 bit or 64 bit Windows operating system or if you're using Office 365.

    Office version

    Location

    Office 365

    C:\Program Files\Microsoft Office\root\Office16

    C:\Program Files (x86)\Microsoft Office\root\Office16

    Office 2019

    Office 2016

    C:\Program Files\Microsoft Office\Office16

    C:\Program Files (x86)\Microsoft Office\Office16

    Office 2013

    C:\Program Files\Microsoft Office\root\Office15

    C:\Program Files (x86)\Microsoft Office\root\Office15

    Office 2010

    C:\Program Files\Microsoft Office\root\Office14

    C:\Program Files (x86)\Microsoft Office\root\Office14

  2. Locate the correct folder and double-click SelfCert.exe.

    The Create Digital Certificate dialog box appears.

  3. In the Your certificate's name box, type a name for the new test certificate.

  4. Click OK twice.

Top of Page

Digitally sign an Access 2007 or Access 2010 database

For Access 2007 or Access 2010, it's easy and fast to sign and distribute a database. You can package the file, apply a digital signature to the package, and then distribute the signed package to other users. The Package-and-Sign feature places the database in an Access Deployment (.accdc) file, signs the file, and then places the signed package at a location that you determine. Users can then extract the database from the package and work directly in the database (not in the package file). For more information, see Package and sign an Access 2007 and 2010 database.

Top of Page

Digitally sign an Access 2013 or later database

For Access 2013 or later databases, you can apply a digital signature to the components in the database. To code sign a database, do the following:

  1. Open the database that you want to sign.

  2. On the Database Tools tab, in the Macro group, click Visual Basic to start the Visual Basic Editor, or press ALT+F11.

  3. In the Project Explorer window, select the database or Visual Basic for Applications (VBA) project that you want to sign.

  4. On the Tools menu, click Digital Signature.

    The Digital Signature dialog box appears.

  5. Click Choose to select your test certificate.

    The Select Certificate dialog box appears.

  6. Select the certificate that you want to apply. For more information see Get a security certificate.

    If you followed the steps in the previous section, select the certificate that you created by using SelfCert.

  7. Click OK to close the Select Certificate dialog box, and click OK again to close the Digital Signature dialog box.

Notes If you want to prevent users of your solution from accidentally modifying your VBA project and invalidating your signature, lock the VBA project before signing it. However, locking your VBA project doesn't prevent another user from replacing the digital signature with another signature. Corporate administrators might re-sign templates and add-ins so that they can control exactly what users may run on their computers.

Top of Page

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×