Blocked! How to Deal With the New Security Risk Warning in Microsoft Access

In this Microsoft Access Fast Tip video, I'm going to show you how to deal with the new security risk warning message that appears whenever you try to open a database that you have downloaded from the web or received in an email.

LEARN MORE:

LINKS:

BECOME A MEMBER:

ADDITIONAL RESOURCES:

KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, unblock file, unblock folder, security warning, security risk, microsoft has blocked macros from running because the source of this file is untrusted, this file came from another computer and might be blocked to help protect this computer

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[ariannefoster]

I just had to thank you! You explained this so well & helped me fix this issue quickly for an assignment.~I am learning Access & have a module w/Macros, which your video helped me Much faster than searching through others & my textbook.🙏Thanks! 😊

[Jojosmith]

I already thumbed up and subscribed Daniel Pineault as your instruction. thumbs up to Richard the greatest Access teacher as always. Thank you Richard

[harisbihorac]

I have a software I developed that creates a report at the end of a process, opens a rtf, creates a report of the process, converts it to PDF and then displays / prints it to a user. I keep running into the security warning "Some Content Blocked" and gives me "unblock" and "OK" options.
Everything I find online to either trust desktop folder or fix this, instructs me to trust settings via a Microsoft Office app. I watched your video and it seems to be more of a DB / file with PDF> My scenario seems a bit different, can you guide me in the right direction?

[spacemansproggit]

I just wanted to add that good though this video is, there were other changes that Microsoft made to Trust settings at the same time that this solution doesn't fix.

Specifically, I have a "family NAS" box on my home network - it's a QNAP TVS-672XT - and all my family Windows PCs connect to it using regular CIFS drive mapping (based on NAS IP address).

Now, that model has always been unacceptable to the Office Trusted Locations protection, but the previously working solution was as follows:-

1. Go to Trust Center as per Richard's video, here
2. Select Trust Center settings
3. Select "Add new location"
4. Select "Browse"
5. Scroll to the bottom of the locations tab [left part of browse window] where you should see local Drives [by letter], any Mapped Network Drives [also by letter] and then "Network"
6. Open "Network" and locate your network file sharing resource and single-click on it's icon
7. In the panel to the right, a list of available "Shares" will now appear, with an icon that looks like an open beige folder hovering over a "network" T-Junction
8. Double-click on your "Share" of choice, at which point the display will show the top level folder structure present in the root of that Share
9. Navigate as far down the structure as required
10. Click OK
11. In my case, when I do this I see a new "User Locations" value added, with values:-
Path = \\TVS672XT\Public\Data\
Description = {empty}
Date Modified = {Today}

Yet, despite doing this, the "added", trusted location is not trusted by Access.
What is really interesting is that the above solution has worked flawlessly for about the last 2 years or so. Prior to that it was possible to go to the "Add new location" button and type in a location by hand, such as "172.16.101.2\Public\Data" and Access would immediately trust that. Then Microsoft made a change and the only way I was able to get round it was by using the long-hand browse approach (and I'm still not sure why this gives a different result) but with this latest change the system seems to be completely broken.

I have a sneaking suspicion (nothing proven yet) that this is actually nothing to do with Office security and might instead be something to do with my network settings. My machine has a statically assigned IP address - as does my NAS - and everything on my home network is set to the class B network of 172.16.*.*, with a 16-bit subnet mask. Everything else on my workstation seems just fine, but Access adamantly refuses to trust anything on my NAS, even though it's on my local (home) network. My network profile is set to "Private"...

I don't think anybody minds when Microsoft make changes to keep their platform and applications secure, but there is nothing listed, anywhere, to document what this change is, why it was made, or how to fix the damage it has caused. This is not at least the second time that Microsft's "security" has broken something that should be trivially easy to set up.

Thanks for posting the video, Richard. Hopefully someone will see my diatribe and offer a solution!

[Biologicallyx]

God finally i found the answer only took 2 minutes with your help. I have to take this trash Acess course for School.

[richardmeborg]

Hi Richard. When I try to open up a form, then Access just freezes, and I have to use taskmanager to close access. And I cant fiox it. All other forms opens with out any problem

[DanielPineault]

FYI, YouTube has just notified me that they're removing my link/blog article on the subject sighting a violation of their "harmful and dangerous policy" and now FireFox is reporting it as harmful content. I am at a loss for words. I contested and they agreed that it wasn't an issue, yet my webpage remains blocked via FireFox.