By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,391 Members | 2,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,391 IT Pros & Developers. It's quick & easy.

How to add registry key on Access 2007 developer

P: 3
i need to create a trusted folder for access 2007 runtime to do that I need to add a registry key by using wizard on access 2007 developer. whenever i started package solution wizard it prompts me to a registry key addition screen and asks for root key name and value i have found some code from the archive but dont know how to modify it for wizard can some one help me with the details.
the code that i found is

The security system changed in A2007.
You have to determine a Trusted Location (folder) for your accdb.
In full version that's done by adding the place to a list under Access
options. Runtime has no office menu button. So you have to add the folder to
the registry manually adding a locations key, e.g.:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted
Locations\Location1]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo1"

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted
Locations\Location2]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo2"

Thank you
Sep 4 '07 #1
Share this Question
Share on Google+
7 Replies


ADezii
Expert 5K+
P: 8,669
i need to create a trusted folder for access 2007 runtime to do that I need to add a registry key by using wizard on access 2007 developer. whenever i started package solution wizard it prompts me to a registry key addition screen and asks for root key name and value i have found some code from the archive but dont know how to modify it for wizard can some one help me with the details.
the code that i found is

The security system changed in A2007.
You have to determine a Trusted Location (folder) for your accdb.
In full version that's done by adding the place to a list under Access
options. Runtime has no office menu button. So you have to add the folder to
the registry manually adding a locations key, e.g.:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted
Locations\Location1]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo1"

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted
Locations\Location2]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo2"

Thank you
  1. First of all, I must warn you that MANUALLY EDITING THE SYSTEM REGISTRY IS A VERY RISKY BUSINESS even if you know what you are doing. Having stated this, and getting it off my chest, the following instructions should enable you to make the required entries manually.
  2. Run Regedit.exe to Open the Registry Editor.
  3. Select File ==> Export ==> Select 'All' in the Export range ==> Save. These actions will save your System Registry (*.reg) to the location that you specified.
  4. Navigate the Main Registry Key HKEY_CURRENT_USER as far down as you can until you need to Add a New Key Value. You may be able to get to Trusted Locations but I'm really not sure.
  5. When you need to add a New Key, right click on the last Key referenced then New ==> Key ==> Type in Key Name such as Location1, Location2, etc. ==> Enter.
  6. When it comes time to enter the 2 Values under Location1 or Location2, select either Location.
  7. Right Click Location ==> New ==> DWORD Value ==> AllowSubFolders ==> Enter. The Type Field will automatically be generated (REG_DWORD).
  8. Right Click on AllowSubFolders ==> Modify ==> 1 ==> Enter.
  9. Right Click Location ==> New ==> String Value ==> Path ==> Enter. The Type Field will automatically be generated (REG_SZ).
  10. Right Click on Path ==> Modify ==> C:\MyTrustedDatabaseFolderNo? ==> Enter.
  11. Repeate the process for the other Location.
  12. If you run into problems, Import the Entire Registry which you previously Exported via File ==> Import ==> Select File (*.reg) ==> Open.
  13. I have tried to be as precise as possible but this is still a risky business. If you've modified the Registry before, then this should be no problem, if you haven't, then I suggest you get someone who has.
  14. Good Luck and let me know how you make out.
Sep 4 '07 #2

P: 3
  1. First of all, I must warn you that MANUALLY EDITING THE SYSTEM REGISTRY IS A VERY RISKY BUSINESS even if you know what you are doing. Having stated this, and getting it off my chest, the following instructions should enable you to make the required entries manually.
  2. Run Regedit.exe to Open the Registry Editor.
  3. Select File ==> Export ==> Select 'All' in the Export range ==> Save. These actions will save your System Registry (*.reg) to the location that you specified.
  4. Navigate the Main Registry Key HKEY_CURRENT_USER as far down as you can until you need to Add a New Key Value. You may be able to get to Trusted Locations but I'm really not sure.
  5. When you need to add a New Key, right click on the last Key referenced then New ==> Key ==> Type in Key Name such as Location1, Location2, etc. ==> Enter.
  6. When it comes time to enter the 2 Values under Location1 or Location2, select either Location.
  7. Right Click Location ==> New ==> DWORD Value ==> AllowSubFolders ==> Enter. The Type Field will automatically be generated (REG_DWORD).
  8. Right Click on AllowSubFolders ==> Modify ==> 1 ==> Enter.
  9. Right Click Location ==> New ==> String Value ==> Path ==> Enter. The Type Field will automatically be generated (REG_SZ).
  10. Right Click on Path ==> Modify ==> C:\MyTrustedDatabaseFolderNo? ==> Enter.
  11. Repeate the process for the other Location.
  12. If you run into problems, Import the Entire Registry which you previously Exported via File ==> Import ==> Select File (*.reg) ==> Open.
  13. I have tried to be as precise as possible but this is still a risky business. If you've modified the Registry before, then this should be no problem, if you haven't, then I suggest you get someone who has.
  14. Good Luck and let me know how you make out.
Adezii thanks for your help i tried it worked manually but i wanted to add it to my installation executable through Access 2007 Developer Extensions which creates it automatically. on a certain point it asks if i want to add a registry key or not. and after that point i need to type inputs for key , name and value options and select a root from the list which contains all user etc. this is the image from the Microsoft help page.
Sep 5 '07 #3

ADezii
Expert 5K+
P: 8,669
Adezii thanks for your help i tried it worked manually but i wanted to add it to my installation executable through Access 2007 Developer Extensions which creates it automatically. on a certain point it asks if i want to add a registry key or not. and after that point i need to type inputs for key , name and value options and select a root from the list which contains all user etc. this is the image from the Microsoft help page.
If you have the option to automatically add values to the Registry by some GUI, by all means use it. I was under the mistaken idea that you wanted to add the entries manually. Glad it worked out for you.
Sep 5 '07 #4

P: 3
out of the following code can you explain to me which part is the root which part is the key , which part is the name and which part is the value so i can modify my installation file forgot to tell i am using a virtual machine so i am willing to try anything
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted
Locations\Location1]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo1"
Sep 5 '07 #5

P: 1
I added a registry key manually as directed, and at least didn't seem to screw anything up. However, I am still getting the security warning on startup. My "trusted location" is on a network drive, not a local drive, so I think I have to also find a way of editing the registry that is the same thing as clicking the "Allow network locations" box in the Trust Center.

After reviewing the Registry settings on the one PC where I have the full version of Access installed, it looks as if there is a Registry setting:
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\TrustedLocations
AllowNetworkLocations(REG_DWORD) = 1

So I added this manually to the PC where I have only Access Runtime installed. Again, didn't seem to break anything, but I'm still getting the security warning everytime I start the Access application. Tried rebooting, no help.

ANy other ideas?
Oct 4 '07 #6

P: 1
I would like to answer the solution. I can't find registry Key Type field in Access Develeoper Extensions. On MS WEB page it seems good but not in a real situation.
Thedeli, could you solve the problem?

Thanks for answers.

Z
Apr 8 '08 #7

mshmyob
Expert 100+
P: 903
Create a text file with the .REG extension and put this in it and it will eliminate the Trusted Location on your computer.

Run this file on any computer you want to install the runtime on.

This will eliminate needing a trusted directory and will remove the message from Runtime.

Is this what you want?

Expand|Select|Wrap|Line Numbers
  1. REGEDIT4
  2.  
  3. [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
  4. "VBAWarnings"=dword:00000001
  5.  
cheers,
Apr 8 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.