Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access XP Macro Security not an option

Discussion in 'Information Technology' started by Jerid B, Jul 28, 2006.

  1. Jerid B

    Jerid B
    Expand Collapse
    Guest

    I have a database and everyone except one person gets the secutiy message
    about the macro. I assumed her was set to high. I went to change it to medium
    and it's not there under Tools/Macro/Security. There's actually no option for
    security.
    So I check out other 2002 users and they don't have that option.
    I have it in Excel (which I changed hoping it would work with Access too).
    Did not work.
    How can I chnage it in 2002?
     
  2. Loading...


  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Jerid B wrote:
    > I have a database and everyone except one person gets the secutiy
    > message about the macro. I assumed her was set to high. I went to
    > change it to medium and it's not there under Tools/Macro/Security.
    > There's actually no option for security.
    > So I check out other 2002 users and they don't have that option.
    > I have it in Excel (which I changed hoping it would work with Access
    > too). Did not work.
    > How can I chnage it in 2002?


    On some installs the menu options are not there by default. If you go into
    "customize" for that menu and choose "Reset" the macro security options
    should show up.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. Jerid B

    Jerid B
    Expand Collapse
    Guest

    I tried that and it did not work.

    Thank you

    "Rick Brandt" wrote:

    > Jerid B wrote:
    > > I have a database and everyone except one person gets the secutiy
    > > message about the macro. I assumed her was set to high. I went to
    > > change it to medium and it's not there under Tools/Macro/Security.
    > > There's actually no option for security.
    > > So I check out other 2002 users and they don't have that option.
    > > I have it in Excel (which I changed hoping it would work with Access
    > > too). Did not work.
    > > How can I chnage it in 2002?

    >
    > On some installs the menu options are not there by default. If you go into
    > "customize" for that menu and choose "Reset" the macro security options
    > should show up.
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
    >
    >
    >
     
  5. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Jerid B wrote:
    > I tried that and it did not work.
    >


    I'm sorry, my brain is dead today. Those options did not exist until Access
    2003.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     

Share This Page