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! 😊
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!
Have you resolved your problem yet? I got into the same problem, and I solved it by following Microsoft instruction: 1. Windows key -> type in Internet Options 2. When it is opened, choose Security tab > Trusted Site > Sites 3. Type in file://{your network} (in your case: file://172.16.101.2), then Add 4. Uncheck the https option box (Sorry I forgot what it said, but there is only 1 checkbox) > Close > OK. 5. Open your Access and I think you're good to go. Hope this help anyone with the same problem.
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?
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
FYI, TH-cam 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.
Wow. I'm at a loss for words too. This isn't harmful or dangerous content. This is teaching people to understand what's going on and showing developers how to work with it. People need the ability to share databases, especially professional developers.
I see 17 hours later that it's still there. I would think that if TH-cam were going to do that, they would have done it right away. Are you sure the notice was from a legit source? I've posted several videos on how to get around security (like my Trusted Location video) and I've never had any problems.
Yet another reason not to use Firefox. LOL. No... seriously... that's dumb. I can't see how anyone would find your video dangerous in the least. Fortunately, it's still showing up on TH-cam.
![[UNCUT]“ฅนตื่นธรรม”ปะทะ“หมอปลา-ปู่มหามุนี-อั๋นโอกิ”สะเทือนกระทรวงเวทมนตร์ Iคนดังนั่งเคลียร์I10 ตค.67](http://i.ytimg.com/vi/peMD_SAkwNc/mqdefault.jpg)
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! 😊
Glad it helped!
I already thumbed up and subscribed Daniel Pineault as your instruction. thumbs up to Richard the greatest Access teacher as always. Thank you Richard
You're very welcome
Thank you.
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!
Thanks for sharing!
Have you resolved your problem yet? I got into the same problem, and I solved it by following Microsoft instruction:
1. Windows key -> type in Internet Options
2. When it is opened, choose Security tab > Trusted Site > Sites
3. Type in file://{your network} (in your case: file://172.16.101.2), then Add
4. Uncheck the https option box (Sorry I forgot what it said, but there is only 1 checkbox) > Close > OK.
5. Open your Access and I think you're good to go.
Hope this help anyone with the same problem.
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?
Thank you!
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
599cd.com/Trouble
Many thanks sir.
You are most welcome
God finally i found the answer only took 2 minutes with your help. I have to take this trash Acess course for School.
FYI, TH-cam 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.
Wow. I'm at a loss for words too. This isn't harmful or dangerous content. This is teaching people to understand what's going on and showing developers how to work with it. People need the ability to share databases, especially professional developers.
I see 17 hours later that it's still there. I would think that if TH-cam were going to do that, they would have done it right away. Are you sure the notice was from a legit source? I've posted several videos on how to get around security (like my Trusted Location video) and I've never had any problems.
Yet another reason not to use Firefox. LOL. No... seriously... that's dumb. I can't see how anyone would find your video dangerous in the least. Fortunately, it's still showing up on TH-cam.
Top video
thanks
THANK YOU SO MUCH