Access: Trust Network Locations
Reference
https://www.mrexcel.com/board/threads/adding-a-shared-network-drive-as-a-trusted-location.1209086/
Spent about half an hour looking for solution for this so here what solved it for me:
1) Open start menu and look for Internet Options
2) Go to Security
3) Trusted Sites
4) Sites
5) Untick Require server verification (https) for all sites in this zone
6) Add the drive (you can add just the mapped drive letter, and it will convert it to UNC, or just the ip of the host)