• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 432
  • Last Modified:

Hyperlink error

I have a table that contains a hyperlink field.  The hyperlinks are all "TIFF" images on my in-house domain.  I've tried all the security settings, registry edits and I still receive the same error message.  "Some files can contain viruses or otherwise be harmful to your computer...."  There has to be an easy way to fix this without doing all this registry editing, creating digital signatures etc.  (isn't there?)
3 Solutions

menu bar > tools > macro > security, then set it to low
Hi davcos,
>  "Some files can contain viruses or otherwise be harmful to your

From the MS article on this subject:
The warning message described in the "Symptoms" section of this article is issued by Microsoft Office. This warning is referred to as the "open programs" warning, not the "macro virus protection" warning. It appears any time that you click a hyperlink to a program or run a program. You also receive this warning when you click a hyperlink to certain types of document files. You cannot disable this warning. Similar behavior occurs in other Microsoft Office programs that allow you to use hyperlinks.

This feature is designed into Microsoft Office to help protect you from malicious code.

davcosAuthor Commented:
Actually I had to perform those steps to even be able to open the database when we upgraded to MSA2003.  I have numerous macros, and I had to set the security to "low" to enable macros.  It seems there should be some way to trust a database that has been entirely built in-house.  I forgot to say that I am using MS Access 2003 (SP2)

davcosAuthor Commented:
This aticle from MS says that you can disable the message.  http://support.microsoft.com/?kbid=829072
It does not work.  Why would opening a tiff image from access be a problem.  I don't recieve an error when opening the file across the network.  The "TIFF" file extension is associated with another MS application.  Can't I "trust" my own domain?  Kriekie!
Jeffrey CoachmanMIS LiasonCommented:

To "Trust" your own code you may have to create your own "Digital Signature", using the "selfcert.exe" utility.
(Try this on a test machine first!)

(The steps listed here are for excel 2000, but are virtually identical for Access 2003.)

Maks sure the security level is NOT set to "HIGH"

Create Digital Signature
To use the macros safely, you need to create a digital signature for yourself and sign the macros. To do this, you need to have SelfCert.exe installed. If it is installed, it is probably at
C:\Program Files\Microsoft Office\Office

If SelfCert.exe isn't already loaded, here is how to install it:
1.      Go to the Start menu and select Control Panel.
2.      Click on the Add/Remove Programs icon.
3.      Make sure that the Change or Remove Programs icon in the upper left is selected.
4.      Select Microsoft Office 2000 and click on the Change button.
5.      Expand Office Tools by clicking on the plus sign (+).
6.      Select Digital Signature for VBA Projects and set it to Run from My Computer.
7.      Click on the Update Now button. (At this point, the installation program will probably ask you for your Microsoft Office 2000 CD-ROM installation disk.)
To create your certificate, start SelfCert.exe and enter your name. This will create a digital certificate for your personal use.
Sign the Macros
Finally, you need to actually sign the macro with this new certificate.
1.      Inside the Visual Basic window, select Tools->Digital Signature.
2.      Click on the Choose button.
3.      Select the certificate that you just created.
4.      Click on the OK button.
5.      Select File->Save.
That's it! You should be in business now.

I hope this helps as well
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

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now