Question How do I open access in runtime without security warnings?

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.
 
NOTE: A glitch in the forum software makes it appear as if there is a space in 'Access' - its an illusion!

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
 
Hi

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

Code:
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations]

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location0]
"Path"="D:\\Colin\\My Documents"
"AllowSubfolders"=dword:00000001
"Description"="My Documents"
"Date"="29/06/2017 17:50"

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location1]
"Path"="G:\\MyFiles"
"AllowSubfolders"=dword:00000001
"Description"="My Files"
"Date"="29/06/2017 17:50"

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location10]
"Path"="C:\\Programs\\MendipDataSystems"
"AllowSubFolders"=dword:00000001
"Description"="Mendip Data Systems"
"Date"="08/12/2015 19:51"

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location2]
"Path"="C:\\Program Files\\Microsoft Office\\Office14\\ACCWIZ"
"Description"="Access default location: Wizard Databases"

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location3]
"Path"="G:\\MyFiles\\CEO"
"AllowSubfolders"=dword:00000001
"Description"="CEO"
"Date"="29/06/2017 17:50"

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location4]
"Path"="G:\\MyFiles\\SchoolDataAnalyser"
"AllowSubfolders"=dword:00000001
"Description"="SDA / SDA Link"
"Date"="29/06/2017 17:50"

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location5]
"Path"="G:\\MyFiles\\SPS"
"AllowSubfolders"=dword:00000001
"Description"="SPS"
"Date"="29/06/2017 17:50"

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)

Hi ridders,

your solution is working like a charm !!!
Sorry for ma late answer.

Best wishes,
Jacek Antek
 
Hi Guys,

it is still a problem here...

what if i have to refer to UNC path ?

I have tried :

Code:
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location4]
"Path"="\\nt-wro4-01\\dane\ihrm\\dokument\\worek\\KADRY\\DOKUMENTY _BRAKI\\"
"AllowSubfolders"=dword:00000001
"Description"="SDA / SDA Link"
"Date"="29/06/2017 17:50"

but warning are showing here...

Please help,
Jacek Antek
 
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

attachment.php


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 ....
 

Attachments

  • Capture.PNG
    Capture.PNG
    35.7 KB · Views: 644
UPDATE:
I did some googling on this and it's a common issue
I think MS have deliberately made this harder for security reasons

These links were useful:
https://social.technet.microsoft.com/Forums/office/en-US/9ac965b6-0bbf-433e-9ffd-933a7254bf27/path-cannot-be-used-as-a-trusted-location-for-security-reasons?forum=word
https://social.technet.microsoft.com/Forums/office/en-US/9a4b5a04-8863-4c17-ae94-23fb790c448c/cannot-define-office-2007-trusted-locations-on-our-server

The 2nd link gave a solution which worked for me:

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.

attachment.php


NOTE;
1. I had to untick the checkbox before I could add the site
Thought it a good idea to tick again when done

2. It may be that this makes the specified network location less secure.
Use at your own risk
 

Attachments

  • Capture.PNG
    Capture.PNG
    44.3 KB · Views: 637
Hi ridders,

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...

What is going wrong here?

Please help,
Jacek Antek
 

Attachments

  • Bez tytu?u.png
    Bez tytu?u.png
    34.3 KB · Views: 166
Ok i got this and this is still not working:
 

Attachments

  • Bez tytu?u.png
    Bez tytu?u.png
    15 KB · Views: 145
Sorry can't offer any other ideas
You'll need to research using Google
 

Users who are viewing this thread

Back
Top Bottom