I've been a microsoft developer for decades, and I've lived through all the debacles (such as the ADOX .dll versioning debacle), this one is really annoying me. I'm on Office365 currently and deploy the 2016 RTE for my application
So I have backend database that i will put on a QNAP NAS network share \\10.10.10.50\HRShare\Backend.accdb
This has worked for a decade + . I have code that I run on the first time a user installs the software that adds trusted locations to the registry and whenever a user reconnects to the backend database i add that location as well.
I guess with this new update in 22 that finally just hit my channel IP Addresses no longer work and it wants to FORCE me to use a hostname. How can i get around this? I go on road shows all the time and IP Address (LAN) always works and hostname works sometimes at best depending on the FLAT VLAN and QNAP im using. In other words it takes me a lot of unnecessary time to troubleshoot the DNS or add the Hostname to the HOSTS file when i have 20 users setup.
When I take a look at the trusted locations it shows my ip address is greyed out, it wont let me add in any ip addresses or map a network drive with an ip address only the HOST Name will work but that has its own large set of probelms as i mentioned earlier. I even tried adding the ip address to the Internet options trusted zone file://10.10.10.50 but nothing works with IP address anymore. If I add that ip address via VBA to the registery it shows up greyed out in my trusted locations (pic attatched) is there another place in the registery where i can make it "not greyed out?"
I read and tried every option on this article but no go https://www.isladogs.co.uk/unblock-motw/ Would a code signing certificate solve this? I've always been able to work around the code signing and macro nonsense with raw VBA / Registery / API strategries but im at my wits end with this one.
I have a reconnectbackend proc that re-links all tables in the backend after you select the path, thats when i get the issue reconnecting to an access .accdb which only has tables in it. This is the old issue that i used to get back around 2010 and you could hit ok to every table and it would link them eventually, but of course thats when i setup trusted locations via VBA to automate the nonsense, but now it looks like that has changed.
Under Macro Settings I have Enable ALL MACROS not not reccomended and im attatching photos of my trust center and internet options. If I have to I will make a hosts file entry programmatically on every computer harcoding the hostname and swapping out the IP address before I connect to the backend but that is so stupid, but its equally stupid that i can't use IP address anymore and must use a host name!! MICROSOFT!!!!!!!!!!
Any thoughts?
Thanks,
David