Hyperlink error

Posted on 2006-05-10
Last Modified: 2012-06-27
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?)
Question by:davcos
    LVL 27

    Accepted Solution


    menu bar > tools > macro > security, then set it to low
    LVL 77

    Assisted Solution

    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.


    Author Comment

    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)


    Author Comment

    This aticle from MS says that you can disable the message.
    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!
    LVL 74

    Assisted Solution

    by:Jeffrey Coachman

    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

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now