Digitally Signing the Access VBA Project

[thebatfink]

Hi,

I have a query regarding signing my database. I have purchased a code signing certificate from Comodo. I have signed the VBA project and then set users security to 'Only enabled macros which are digitally signed' but when the database is opened it still gives the prompt 'Some active content has been disabled' and the user has to click 'Enable Content'.

Why does Access decide it should still disable the content when it is signed?

Thanks!
Batfink

 

[Neobeowulf]

Are you digitally signing a database that is in .mdb? If you are, you should just be able to go to [Database tools] --> [Visual Basic] --> [Tools] --> [Digital Signature]. Once you sign it, close & reopen the database. You'll still see the "Enable content" popup, but this time you should have an option to "Trust publisher". Once you pick trust publisher, you shouldn't see the security warning again.

Now for accdd extension...can't help you there. I think you have to adjust your trust center options.