Share via

MS Access: "The active content in this file is blocked"

Anonymous
2024-06-20T12:37:08+00:00

I am getting the "The active content in this file is blocked" error from MS Access despite the following updates as suggested by various posts on this site and others. Any additional suggestions would be appreciated.

In Internet Properties:

  • Where the file is located has been added to the list of Trusted Sites.

In Trust Center Settings:

  • Where the file is located has been added to the list of Trusted Locations in MS Access.
  • In Trusted Documents, the Allow documents on a network to be trusted is checked.
  • In Macro Settings, the Enable all macros is selected.
Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-06-21T15:37:47+00:00

    Figured out the answer late yesterday (20-Jun).

    TLDR Answer:

    Use a named location (\servername\folder\filename), not an IP address (\1.2.3.4\folder\filename)

    Full Answer:

    I went to add the IP Address to the list of trusted sites in addition to the named location that was already in the list. Access threw an error modal saying that The path you have entered cannot be used as a Trusted Location for security reasons. Choose another location or a specific folder.

    This led me to try copying the file from the network location to the user's desktop and it worked fine.

    Then I looked at the shortcut and noticed it's listed location was \1.2.3.4\folder\filename and changed it to \servername\folder\filename. Once I did that the program was able to launch without a problem.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2024-06-21T15:32:08+00:00

    That checkbox is not available.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. George Hepworth 22,855 Reputation points Volunteer Moderator
    2024-06-20T13:52:34+00:00

    Wait, there is another user, on a different computer, where the problem occurs?

    Did that other user also set the appropriate security settings for his installation of Access?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-06-20T13:05:54+00:00

    It comes from a server on the network here where I am located and was transferred to a server on the network where my colleague is located. He has admin access to the network location, and the same file runs just fine on a different computer on the same network.

    Was this answer helpful?

    0 comments
  5. DBG 11,711 Reputation points Volunteer Moderator
    2024-06-20T12:42:40+00:00

    Where did the file come from? Does it have the mark of the web?

    Was this answer helpful?

    0 comments