Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro Security (Access 2002)

    I am trying to set the macro security level in a database, but when I go to tools and point to macros, security is not an option. I have used the help feature in Access to search for how I would go about adding this as an option, but I couldn't find anything. Any suggestions would be greatly appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Macro Security (Access 2002)

    Welcome to Woody's Lounge!

    A macro in Access is quite different from its namesakes in other Office applications. A macro in Word, Excel or PowerPoint is a VBA procedure without arguments. VBA code in Access is organized in modules, and macros are separate, with their own set of instructions.
    Moreover, while it is quite possible to create a useful Word document or Excel spreadsheet without any macros, almost all serious Access database applications involve macros and/or VBA code. Disabling macros as in Word or Excel would make using such databases impossible. So you can't set a macro security level in Access (I repeat, I don't know about Access 2003).

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macro Security (Access 2002)

    There is "macro security" in 2003 but not in Access 2002, so don't bother to try and find it there.
    Charlotte

Posting Permissions

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