dplaut - true, which is why at our Dept. of Defense site the group policy prevented that portion of the registry from being edited by making it have read-only permissions for anyone who wasn't a security admin. Which would of course mean that the solution can be easily blocked by an alert domain manager.
This doesn't happen if the text is put between code tags.
Elsewhere it is inserted automatically to break long lines of text that don't contain any spaces. Without it, a single instance of unbroken text anywhere on the page could drive the right margin right off the screen.
This doesn't happen if the text is put between code tags.
Elsewhere it is inserted automatically to break long lines of text that don't contain any spaces. Without it, a single instance of unbroken text anywhere on the page could drive the right margin right off the screen.
Hi Greg
I had deliberately used quotes rather than code to indicate as registry code, it wasn't VBA.
I wrongly thought both quote & code tags prevented the incorrect addition of a space.
Anyway, thanks. I've now edited the post accordingly
In case its of any use to you, I've exported the registry entries for trusted locations with Access 14.0 on my PC.
If you look at this list, it shows a list of all folders where any databases are trusted.
What you will also notice is there is no entry for the location of the Access runtime itself.
That's not relevant here - AFAIK that's true even if using the runtime version
I've attached this as a registry file (.reg) - zipped so I could upload it here.
Open it in Notepad to edit it for your own purposes
Some comments on the above:
1. Add an entry for each trusted folder. The location number doesn't matter as long as its unique
2. Modify the path as required for your setup - notice the double backslashes
3. If you want to trust subfolders, use dword:00000001
If not, use dword:00000000
4. Add a user friendly description (optional) and modify the date if you wish.
When I'm deploying databases to clients I create registry scripts similar to the above but with additional entries for Office 12/15/16 (2007/2013/2016)
I have a vague memory of trying this in the past & failing
See if either of these work for you (not tested)
a) In Access, go to Trust Center => Trusted Locations
Tick Trusted locations on my home network if not already done
b) This is pure speculation and probably nonsense
As the registry seems happy with double backslashes and the UNC path should start with \\, try it with 3 or possibly even 4 \ at the start
c) If neither of these work, try entering the UNC path manually in Trust Center => Trusted Locations and 'tweak' it until it works
It will be added to the registry automatically.
If you succeed, please post your solution
If none of those work, Google it ....
There appears to be a very simple workaround to this
Open Internet Options (in Control Panel), click on Security ...Trusted Sites ...Sites and add the IP address to your 'Trusted Sites', (file:IP address).
e.g. file//192.168.0.1
Sites listed in your Trusted Sites seem to also be treated as Trusted Locations in Office.
thank you very much !
I tried your methods and it did not work ufnortunately. Additionally i have only access runtime on server so i could not change the trusted located from there.
So i have tried to go to control panel and into security.
Trusted sites without writing "https" is not allowed on my computer - please see in my attachment...
