Macro security!




I am using Access 2003 in which I created a database a couple of years ago.
I recently re-installed Windows XP on my machine and now everytime I open my
database I get a window saying:

"This file may not be safe if it contains code that was intended to harm
your computer. Do you want to open this file or cancel the operation."

I have the following choices:

If I choose "MORE INFO" I get the folowing explaination:

"About helping protect files from macro viruses A macro virus is a type of
computer virus that's stored in a macro, Visual Basic for Applications (VBA)
code, a form that contains an ActiveX control, a report that contains an
ActiveX control, action query, data-definition query, pass-through query, or
update query. To help protect against macro viruses, you should purchase and
install specialized antivirus software.

For more information about using antivirus software with Microsoft Office
2003, see the Microsoft Office Online Web site.

To further help reduce the risk of macro infection in Office files, set the
macro security level to High or Medium and use digital signatures.

Security levels for macros

The levels of security to help reduce macro virus infection are as follow:

Very High This setting is not available in the Security dialog box in
Microsoft Office Access 2003. It is possible, however, to use system policies
to set the security level in Access to Very High. When the security level is
set to Very High, Access cannot open any Access database or Access project
High You can open files that have been digitally signed and that you confirm
are from a trusted source Before deciding to trust a source, you should
confirm that the source is responsible and uses a virus scanner before
signing macros.
Medium A warning is displayed whenever a file is opened from a source that
is not on your list of trusted sources (described below). You can choose
whether to open the database.
Low If you are sure that all the files and add-ins you open are safe, you
can select this option. At this security level, macros are always enabled
when you open files.
By default, the security level is set to Medium. If the security level is
set to Medium or High, you can maintain a list of trusted macro sources. When
you open a file or load an add-in that contains macros developed by any of
these sources, the macros are automatically enabled.

Digital signatures

A digital signature on a macro is like a wax seal on an envelope— it
confirms that the macro originated from the developer who signed it and that
the macro has not been altered.

When you open a file or load an add-in that contains a digitally signed
macro, the digital signature appears on your computer as a certificate. The
certificate names the source of the macro and provides additional information
about the identity and integrity of that source. A digital signature does not
necessarily guarantee the safety of a macro, so you must decide whether you
trust a macro that has been digitally signed. For example, you might trust
macros signed by someone you know or by a well-established company. If you
are unsure about a file or an add-in that contains digitally signed macros,
carefully examine the certificate before you open the file. If you know that
you can always trust macros from a particular publisher or developer, you can
add that publisher or developer to the list of trusted sources when you open
the file or load the add-in.

You can digitally sign macros from within the Visual Basic Editor.

List of trusted publishers

When you open a file that includes signed macros, you are prompted whether
you want to trust all macros originating from that publisher. If you select
this option, you add the certificate's owner to your list of trusted
publishers. Before you decide to do this, you should review the details of
the digital certificate— for example, look at the Issued to and Issued by
fields to determine whether you trust its publisher, and look at the Valid
from field to determine if the certificate is current. The certificate may
also include details such as the e-mail name or Web site of the person who
obtained the certificate.

Once you add a person (or corporation) to your list of trusted publishers,
Office will enable macros signed by this trusted publisher without showing
you a security warning. You can also remove entries from the list of trusted

Note A source added to the list of trusted publishers will also be trusted
in Microsoft Internet Explorer.

Security warning information "

I have no idea what certificate's owner and list of trusted publishers are
and where to edit these properties?

Basically, I have to lower the macro security, and I don't know where to do

Can someone tell how to set Access macro securities so that this pop up
window does't show when I open Access!

Best regards


On the main toolbar go to Tools, Macro, Security. Set the security
level to Low.


Robby pretended :

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question