Registry values to disable all macro security warnings in Access2007

C

chthomas

Hi,

Am unable to run all macros even after doing registy editing as shown below.
Please advise. Some macros are appearing with an information symbol in design
mode(means won't be executed) Please advise.

Regards,

Charley


Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
"VBAWarnings"=dword:00000001


[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\
Engines]
"SandBoxMode"=dword:00000002

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines]
"SandBoxMode"=dword:00000002


[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access\Security]
"Level"=dword:00000001
 
S

Steve Schapel

Charley,

Have you set up the folder where the database file is as a Trusted Location?
 
C

chthomas via AccessMonster.com

Steve,

Sorry for the delay, the time difference.

I thought that with these registry settings I need not have to mention any
trusted locations. Any way, I doubted it, so tried moving the db to the
default trusted location

C:\Program Files\Microsoft Office\Office12\Accwix

but no luck.
 
A

Albert D. Kallal

The follwing key should work.

Root: HKCU;Subkey:
"Software\Microsoft\Office\12.0\Access\Security";ValueType: dword;
ValueName: "VBAWarnings"; ValueData: "1"

I not needed to set anything else to remove all warmings....
 
C

chthomas via AccessMonster.com

Well, its already set to 1 but for me somehow its not working.
 
L

Luka

It does not help me too.
I tried a lot of things, but no luck. My problem is written 6 questions
below (Acc2000 converted to Acc2007). I have already asked Access experts in
my country. They have no ideas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top