Disable Security Warning in Access Runtime

[sctech]

Only Access Runtime Installed. On open of a mdb file a security warning pop
up box appears. Does anyone know how to disable the security warning box?
Access 2007 program is not installed only the runtime. Thanks.

 

[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

 

[sctech via AccessMonster.com]

Makes very good sense, I will try it..Thank you....from sctech

 

[sctech via AccessMonster.com]

Message For Chris (MVP Microsoft)

Would you know of any other way? Thanks..

 

[Chris O'C via AccessMonster.com]

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 has to 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]

 

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

 

[Chris O'C via AccessMonster.com]

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
the other vendors if you want to distribute a digitally signed Access app to
other pcs, and the recipient has to trust your digital signature.

Packaging the Access 2007 app as an msi with the packaging solutions wizard
should install the Access 2007 app in a folder that's trusted. I don't know
why it didn't work for you. That's supposed to be automatic. I'd suggest
trying again.

Before you packaged the app, did you open it in your Access 2007 retail
version and "enable all macros" in the macros settings?

Chris
Microsoft MVP

Several ways.  

[quoted text clipped - 52 lines]
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.

 

[sctech via AccessMonster.com]

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
the other vendors if you want to distribute a digitally signed Access app to
other pcs, and the recipient has to trust your digital signature.

Packaging the Access 2007 app as an msi with the packaging solutions wizard
should install the Access 2007 app in a folder that's trusted. I don't know
why it didn't work for you. That's supposed to be automatic. I'd suggest
trying again.

Before you packaged the app, did you open it in your Access 2007 retail
version and "enable all macros" in the macros settings?

Chris
Microsoft MVP

On Aug 3, 3:32 am, "Chris O'C via AccessMonster.com" <u29189@uwe>
wrote:

[quoted text clipped - 10 lines]

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

 

[Chris O'C via AccessMonster.com]

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]

 

[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

 

[Chris O'C via AccessMonster.com]

OK, now I see why setting the sandbox mode wasn't working for you. The
registry key you mentioned is for the ACE db engine, and the registry key I
listed earlier was for the Jet 4 db engine. accdb format db files need
sandbox mode set to 2 for the ACE db engine, because Jet settings don't apply.


Thanks for the info.

Chris
Microsoft MVP

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.

[quoted text clipped - 18 lines]
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