Changing security level for compiled app

[John]

I have an Access 2003 app, which displays the message
This file may not be safe if it contains code that was intended to harm your
computer. Do you want to open this file or cancel the operation?

I fixed this by changing security settings within Access, but when I compile
the application and install it on a machine without Access, I get the
message again. Since it is a compiled app, I can not get to the area to
change the security.

You only have to say ok, but the user should not have to do this. How can I
get the security setting to carry through to the compiled app, or changed it
on the machine that has the compiled app, but not Access?

Would appreciate anyones help.

JR

 

['69 Camaro]

Hi, John.

I can not get to the area to
change the security.

You only have to say ok, but the user should not have to do this.

If you are unable -- and your user is unwilling -- to do this, then the bill
for a consultant to fix this won't be cheap! If you are willing to
reconsider this alternative by either changing the Windows Registry settings
or adding code for your application before compiling it into an MDE again,
then please see the "How to set the macro security level in Access 2003
runtime" tip for the source code in both English and Spanish on this Web
page:

http://www.Access.QBuilt.com/html/vba.html#SetMacroSecLvl

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[John]

Great, thanks! I like the registry hack!

Hi, John.



If you are unable -- and your user is unwilling -- to do this, then the bill
for a consultant to fix this won't be cheap! If you are willing to
reconsider this alternative by either changing the Windows Registry settings
or adding code for your application before compiling it into an MDE again,
then please see the "How to set the macro security level in Access 2003
runtime" tip for the source code in both English and Spanish on this Web
page:

http://www.Access.QBuilt.com/html/vba.html#SetMacroSecLvl

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


can changed

 

['69 Camaro]

You're welcome!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)