VBA stopping security warnings with certificates issue

Posted on 2006-10-20
Medium Priority
Last Modified: 2008-02-01
Hope someone can help..

I Have an Access Project with Modules and forms. I want to stop the Security warning from appearing when I start the application. I do not want to edit the Security Level so instead I created and signed my own Digital Certificate and added it to the project. However after I signed the project with the Certificate when I save or close the project, I get the following 2 errors.

1.         "Could not read definitions; no read definitions permission for table or query ......

2.         "There was a problem with the digital certificate. The VBA project could not be signed. The signature will be discarded.

Any help would be greatly appreciated.
As I am trying to distribute the project to a client.

Question by:cstephen100
LVL 13

Expert Comment

ID: 17774129
i think the Digital Certificate does not remove the warning that macros are in the document. it just says that you created it and nobody has tampered with it, which is really no real protection if you think about it. even less if you created the digital certificate for free?

i think the only way to turn that off is to set the security level to Low... maybe somebody can correct me in this one.

for the digital certificate problems, check that you are using a company to create digital certs such as Verisign or something like that, maybe that corrects the problem

hope it helps

LVL 86

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1200 total points
ID: 17778269
Your first error would seem to point to corruption in the database. Make a copy of the db, and then try a Compact/Repair. If that doesn't work, try building a new, blank database and importing all the objects from the old db.

Regarding the macro error: Yes, you can stop this IF you have a digital certificate and it's properly applied.You must digitally sign the VBA project. Here's  a few links that may help:


You'll notice the first paragraph contains this line:

"In High or Medium security, a file signed by a trusted entity will be opened without any security warnings."

As newyuppie mentions, you would need to purchase a digital certificate from a "trusted entity". I got mine from Comodo (http://www.instantssl.com/code-signing/), costs about 100 bucks a year.

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question