VBA Macro Security Alert

[Courtney G]

Every time we open the database we are given the below security warning. We
always choose to enable the content on the database and would like to stop
having to do this every time we open it. Does anyone have any advice?

Thanks in advance!

Courtney

Security Warning: Cerntain content in the database has been disabled
Options:

VBA Macro
Access has disabled potentially harmful content in this database.
If you trust the contents of this database and would like to enable it for
this session only, click Enable this content.

Warning: It is not possible to determine that this content came from a
trustworthy source. You should leave this content disabled unless the
content provides critical functionality and you trust its source.

Help protect me from unknown content (recommended)
Enable this content.

 

[Chris O'C via AccessMonster.com]

Either digitally sign the db or set your macro security on low.

Tools > Macro > Security. Security level = low.

Chris

 

[Courtney G]

Thanks Chris. How can I digitally sign it?

Either digitally sign the db or set your macro security on low.

Tools > Macro > Security. Security level = low.

Chris

 

[Chris O'C via AccessMonster.com]

Buy a digital certificate good for 1 yr from Thawte or VeriSign or one of the
other recognized digital signature companies. Install it on your PC and use
the certificate to sign your file (the company gives you instructions).
Distribute the file. Everybody who opens your db file can choose to trust
your digital signature. Afterwards they don't get the macro security warning
when opening files you've digitally signed.

Only costs $100 to $250 a year for each digital certificate. You have to buy
a separate digital certificate for Microsoft Office files because the digital
certificate used to sign executables won't work with Microsoft Office files.

Chris