Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004

    Unanswered: Where is Tools\Macro\Security in Access 2002

    I have the VBscript that opens an Access database while setting the security level to 1:
    set appAccess=createobject ("Access.Application")
    appAccess.automationsecurity=1 ' set macro security LOW.
    appAccess.OpenCurrentDatabase "TestDB.mdb" ,Exclusive , "Temp"

    The script works in Access 2003, except in some computer with MSAccess 2002 (SP3) version and where the Tools\Macro\Security is not available in menubar. I tried resetting the menubar as some suggested but it doesn't work. So I figured if only the Security can be enabled in the menubar, the script should work. Now, how to do that is my big question and would greatly appreciate any help.


  2. #2
    Join Date
    Mar 2007
    AFAIK it was introduced in Access 2003.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    The whole point of having this security level in Access is to prohibit malicious code from running without your knowledge.

    I figure it would be pretty pointless if that could be bypassed with [malicious] code.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jun 2004
    Thanks, guys and point taken.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts