A useful tool for analyzing and solving problems in every industry and occupation
5
 

How to Manually Add an Access Trusted Location to the Registry

  1. Find out what version of Microsoft Access or Microsoft Access Runtime is installed on your computer. Open Control Panel. In XP click on Add/Remove Programs. In Vista, Windows 7 or Windows 8 click on Programs. Look for Microsoft Office or Microsoft Access Runtime in the list of installed programs. It should have the year number after it. If the year is 2007 you have Office 12. If the year is 2010 you have Office 14. If the year is 2013 you have Office 15. These numbers replace *version* in the next step.
  2. Run the file Regedit (as an Administrator). If your do not know how to run the file Regedit you should not be touching it and you should definitely get someone who knows what they are doing to help you. Drill down to HKEY_Current_User / Software / Microsoft / Office / *version* / Access / Security / Trusted Locations.
  3. Look at the locations listed under Trusted Locations. Typically there is at least one Access default location called Location2. If none of the listed locations contain "C:\Problem Solving\" in the Key labeled Path, you will need to add a new location. If the Path key for one of the locations contains "C:\PROBLE~X\" you can change it to C:\Problem Solving\". If a Trusted Location already exists go no further and close Regedit.
  4. To add a new Location, right click on Trusted Locations and then New and then Key. Rename the New Key to LocationX, where X is the lowest number between 0 and 999 that does not yet exist.
  5. Right click on the new location you have just created, then New, then String Value. Give the new string value the name Path. Right click on the new key Path and click Modify. In the field labeled Value date enter the path C:\Problem Solving\ (make sure you include the backslash at the end".
  6. Right click on the new location again and click New, then DWORD value. Give the DWORD value the name AllowSubfolders. Right click on AllowSubfolders and click Modify. Enter a value of 1.
  7. You can create an optional new string value called Description the same way and give it the name Problem Solving Application. You can also create an optional new string value called Date and give it a date value in the short date format .
  8. If you are adding trusted locations for PSA Net, the network version, you should allow network locations to be trusted. Right click on Trusted Locations and then New and then DWORD. Give the DWORD value the name AllowNetworkLocations. Right click on AllowNetworkLocations and click Modify. Enter a value of 1.

 


 
   
Copyright (c) 2000 - 2013 Problem Solving Pty Ltd