Re: Access 2003 Macros warning

"AA2e72E" wrote in message:
news:07CCF397-0D99-4CAF-82B6-8B1545CB8529@xxxxxxxxxxxxxxxx

> How do you make the macros warning appearing on opening a database in 2003
> revert to the way 2000 handles it? There is no warning in 2000 and a warning
> always appears in 2003 (albeit there is no macros or code in modules):
> security is set to medium in both.

Welcome to Access 2003! 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/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/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 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
>>>>

--
Jeff Conrad
Access Junkie
Bend, Oregon


.

Relevant Pages

  • Re: Access 2003 security warnings
    ... Security in Access is a misnomer. ... You can lock down the mdb files so that people can't get to the database ... Microsoft Access MVP ... Since I do not run 2003, perhaps you could tell me where the macro ...
    (microsoft.public.access.security)
  • UK - Safety fears over new register of all children
    ... Senior social workers have given warning of the dangers posed by a new ... The security fears are fuelled further by the admission that information ... The database, which goes live next year, is to contain details of every one ...
    (alt.true-crime)
  • Re: Security Warning for a form in Word
    ... document based on the template. ... then the warning is inevitable unless the user has Macro ... Security set to Low, which is *not* advised. ...
    (microsoft.public.word.docmanagement)
  • Re: Command Button Wizard
    ... I was just trying to help you find the place to check Macro security. ... When the drop-down menu appears, drag it to Macro, then drop it in the sub-menu when that appears. ... Accounts, User Level Security Wizard, or Encrypt/Decrypt Database - these do ...
    (microsoft.public.access.formscoding)
  • 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)