Re: Security Waning With Access 2003

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Schmidt (jrschmi1_at_facstaff.wisc.edu)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 13:16:11 -0800

Thanks a million, Jeff
John

Jeff Conrad wrote:
> "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,

Relevant Pages

  • Re: Defeating information bars/security warnings in links from Pow
    ... Well, as far as I'm concerned, it's kind of like talking to a brick wall when it comes to Microsoft and "security," but a couple of the MVPs are masochists and keep trying. ... What's new in PowerPoint 2007? ... does work, however, so I'm just going to quickly trigger the security warning ... > the file now opens without the Information bar and its attendant> security ...
    (microsoft.public.powerpoint)
  • [NT] Circumvent Windows XP SP2 Security Features using execCommand SaveAs Function
    ... Get your security news from a reliable source. ... Bypasses the "File Download - Security Warning". ... will trigger a 404 error message as defined above. ...
    (Securiteam)
  • Re: Security Warning
    ... in SP2 always on.Remove Zone Alarm and use only Windows firewall with Don't ... Remove any other security software and leave those I advised only. ... >> You can block ads and such with a good hosts file: ... >>> Please help me removing this unwanted Security Warning sign, ...
    (microsoft.public.security.virus)
  • Re: Security Warning Messages Question
    ... This has to do with the macro security level set for Access. ... Professional Tools into an *.mde module. ... it opens a couple of boxes with warning ... Is there a way to resolve this error "Security Warning Message" when the ...
    (microsoft.public.access.reports)
  • Re: Excel 2007 and Macros
    ... reinstall and see if I can reset the Security that way. ... run macros without any warnings. ... There are also settings here but I think these just reflect the settings ... Security warning doesn't appear.....although that's as expected. ...
    (microsoft.public.excel.misc)