Digital Signatures

[Guest]

How does one enter or provide themselves with a Digital Signature so that the
code will execute when I open a database that I developed? The screens I get
do not offer me the option of "Accepting or Trusting all from this Publisher".

Any assistance would be appreciated.

 

[Scott McDaniel]

How does one enter or provide themselves with a Digital Signature so that the
code will execute when I open a database that I developed? The screens I get
do not offer me the option of "Accepting or Trusting all from this Publisher".

There are several types of Digital Certificates. Are you going to deploy this to other users, over the internet or via
email? If so, you'd probably want to get a commercial certificate from one of the various companies (Comodo is one:
www.instantssl.com). After this, you develop your application and then "sign" the project (this is done in the VBA
Editor interface, in the Tools menu). After signing the app, you then deploy it and the enduser then is prompted to
accept or deny your cert.

Note also that some programming methods are disabled when you install a cert and tell the machine to use Sandbox mode
(which is some of what you must do in order to avoid the security warnings).

You can also build your own certificate (a 'self-certificate'), but in general that's not a great idea if you plan on
deploying this to others.

There is a LOT of information about digital signatures, but these seem to help answer the most common questions:

FAQ about security warnings: http://office.microsoft.com/en-us/access/HA011225981033.aspx#0
About Digital Signatures: http://office.microsoft.com/en-us/access/HP010397921033.aspx
Add a Digital Sig to your project: http://office.microsoft.com/en-us/access/HP010446121033.aspx
Securing Office Solutions: http://msdn2.microsoft.com/en-us/library/aa141455(office.10).aspx

Training videos: http://office.microsoft.com/training/Training.aspx?AssetID=RP011461791033

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