access 2003 security warning

[Guest]

Is there any other way to get rid of the security warning automatically
without having to change the security level fo the Macros. I am creating a
application for about 30 users and it needs to be done automatically, perhaps
by means of VB code or something ??

 

[Jeff Conrad]

in message:

Is there any other way to get rid of the security warning automatically
without having to change the security level fo the Macros. I am creating a
application for about 30 users and it needs to be done automatically, perhaps
by means of VB code or something ??

Here is some information I have compiled on this subject. These should be able
to give you some ideas.

You can to go Tools, Macro, Security and set it to low.
If the security item isn't on that menu, you may need to reset your menubar. See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;833219&Product=acc2003

You can also manually add the following Registry keys:
Set registry as follows:

ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines
Name:SandBoxMode
Value:#00000002

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001

If these are just for your use, you can create a self cert on your computer
and digitally sign your databases. More info at:
http://www.microsoft.com/resources/documentation/office/2003/all/reskit/en-us/seca02.mspx

Other link to see:
http://office.microsoft.com/assista...ID=CH010411421033&CTT=4&Origin=CH010411391033

Frequently asked questions about Access security warnings:
http://office.microsoft.com/assista...ID=HA011225981033&CTT=4&Origin=CH010411391033

More info here:
How to configure Jet 4.0 to prevent unsafe functions from running in Access 2003
http://support.microsoft.com/default.aspx?kbid=294698

Still more info here:
http://www.fmsinc.com/free/tips.html#accesstip19

Another link on the subject:
http://www.access.qbuilt.com/html/vba.html#SetMacroSecLvl

An online course
http://office.microsoft.com/training/training.aspx?AssetID=RC011461801033

And a very interesting work-around presented by TC:IMO the best way is to start the database via a script file which sets
the macro security level to low for that single invocation of Access.
This does not require a certificate, or a registry change, and it does
not affect any other database(s) - just the one being started by that
script.

Eg. in VBScript:

dim o
set o=createobject ("Access.Application")
o.automationsecurity=1 ' set macro security LOW.
o.opencurrentdatabase "full path to your database"
o.usercontrol=true
set o=nothing

 

[Guest]

THANK YOU, THAT LAST PIECE OF CODE WORKED. THANK YOU. THANK YOU. THANK YOU.
YOU HAVE SOLVED MY MAIN HEAD ACHE.

 

[Jeff Conrad]

in message:

THANK YOU, THAT LAST PIECE OF CODE WORKED. THANK YOU. THANK YOU. THANK YOU.
YOU HAVE SOLVED MY MAIN HEAD ACHE.

You're welcome, you're welcome, you're welcome.


Good luck with your project,

 

[Guest]

The VBScript works great for removing the initial warning message but it does
not do the same thing as setting the Macro Security setting to low through
the tools menu. I was having issues with Access 2003 and executing the Eval
function. I was receiving an error 2425: "The expression you entered has a
function name that Microsoft Office Access can't find". Setting the menu
item to low resolved my issue but setting the AutomationSecurity property to
1 from VBScript does not. If I comment out my autoexec macro and open my
database from the vbs file then I can still see my Macro Security setting set
to Medium.