RE: Disable Security Warning in Access Runtime

[Erez Mor]

hi
if you know this mdb can be trusted, and you cant create a new trust
location (since you only have the runtime version), you can move it to the
default trust location access (and runtime) creates at "C:\Program
files\Microsoft Office\Office12\ACCWIZ"
anything in that folder runs with no warnings

good luck
Erez

 

[dhodapp]

Several ways.  

1 - Use the package and deployment wizard to package the app, and setup will
install it in a folder that is automatically trusted.  (Probably too late for
that in your case.)

2 - You could digitally sign the app before deploying and the customer could
accept the digital signature before opening the db.  (Expensive and hasto be
renewed every year.)

3 - The customer could hack the registry.  (Scary thought.  Build a registry
script for them to double click on.)  Create these 3 registry keys:

1 - VBA warnings setting (DWORD):

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\12.0\Access\Security

VBAWarnings = 1

2 - Sandbox mode setting (DWORD):

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines

SandboxMode = 2

3 - Macro security setting, either for all users or current user (DWORD, 1 =
low level):

(For all users on pc)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access\Security

Level = 1

-----------------------
(Or for single user on pc)

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\12.0\Access\Security

Level = 1

Chris
Microsoft MVP

Message For Chris (MVP Microsoft)

Would you know of any other way?  Thanks..

hi
if you know this mdb can be trusted, and you cant create a new trust

[quoted text clipped - 9 lines]

up box appears.  Does anyone know how to disable the security warning box?
Access 2007 program is not installed only the runtime.  Thanks.

I did all of the above
I created a digital sig with office tools
I used package and deploy
I used ADE
I changed the reg settings.
Still the Autoexec RunCode will not pass.

 

[dhodapp]

Check again on the registry's sandbox mode.  If it's not set on 2 the RunCode
macro won't run, even if all your other security settings are correct.
Registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines

Set SandboxMode value to 2

Chris
Microsoft MVP

Thank you Chris.. Wasnt able to do your method but will try and give you
feedback,.thanks again..

Creating a digital signature with office tools only works on *your* pc,not
on other pcs.  You have to buy a digital certificate from Thawte or one of

[quoted text clipped - 17 lines]

I changed the reg settings.
Still the Autoexec RunCode will not pass.

I did a search on sandbox and found another key that after I set it to
2 (was 3) the app opened just fine.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity
Engine\Engines]

"SandBoxMode"=dword:00000002