Re: Security Waning With Access 2003

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 12:52:37 -0800

"John Schmidt" wrote in message
news:ON3Pl5sEFHA.3908@TK2MSFTNGP12.phx.gbl...

> Can anyone tell me how to bypass the Security Warning dialog that comes
> up when I run an .mdb, created with Access 2000 or Access 2002, on a
> machine with Access 2003 installed?
> Thanks for your help.
> John

Welcome to Access 2003 John. Here is some info on this subject:
(Watch out for any possible line wrapping on these links)

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/?id=833219

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/assistance/category.aspx?TopLevelCat=CH790018001033&CategoryID=CH010411421033&CTT=4&Origin=CH010411391033

Frequently asked questions about Access security warnings:
http://office.microsoft.com/assistance/preview.aspx?AssetID=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 from a past post 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

TC
>>>>

Hope that helps, 

-- 
Jeff Conrad
Access Junkie
Bend, Oregon

Relevant Pages

  • Re: Access 2003 "Security Warning"
    ... > What is the best way to stop that "warning" ... If the security item isn't on that menu, you may need to reset your menubar. ... You can also manually add the following Registry keys: ... IMO the best way is to start the database via a script file which sets ...
    (microsoft.public.access.security)
  • Re: Access 2003 "Security Warning"
    ... "Jeff Conrad" wrote: ... > If the security item isn't on that menu, you may need to reset your menubar. ... > You can also manually add the following Registry keys: ... > IMO the best way is to start the database via a script file which sets ...
    (microsoft.public.access.security)
  • Re: Access 2003 "Security Warning"
    ... I too get the security warnings. ... > You can also manually add the following Registry keys: ... > 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. ...
    (microsoft.public.access.security)
  • Re: How to block warnings in ACCESS 2003 concerning unsafe expressions
    ... If the security item isn't on that menu, you may need to reset your menubar. ... You can also manually add the following Registry keys: ... 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. ...
    (microsoft.public.access.forms)
  • Re: Newbie ? using multiple users in one database at same time
    ... I did review the link that John has ... supplied in his response and it was informative but is still advanced. ... access databases on creating a split database that is controlled via login ... no security at all, or you can have a unitary database with Access security - ...
    (microsoft.public.access.gettingstarted)