Welcome to SPN

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

Sign Up Now!

Office 2003 Security Warning;

Discussion in 'Information Technology' started by jody frazier, Jul 28, 2006.

  1. jody frazier

    jody frazier
    Expand Collapse
    Guest

    I develop db in Access for my company (around 200 employees). I have
    developed quite a few db's in Office XP for several several employees over
    the past few years. My company recently just upgrading to Office 2003. So my
    existing db's that I developed in Office XP are not being prompted with a
    Security Warning asking whether or not the expressions should be blocked or
    not. I though that if you choose not to block them the first time you open
    the db in 2003, it would remember this and not ask again for that db. My
    question is how can I turn off the security warning message when the db is
    opening? Please tell me that I don't have to redesign ALL of the hundreds of
    db's I have out there that I programmed in XP????

    Thanks!
    --
    Thanks!
    Jody
     
  2. Loading...


  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Select in the menu bar :

    Tools > Macro > Security

    Set the security to Low

    --
    Good Luck
    BS"D


    "jody frazier" wrote:

    > I develop db in Access for my company (around 200 employees). I have
    > developed quite a few db's in Office XP for several several employees over
    > the past few years. My company recently just upgrading to Office 2003. So my
    > existing db's that I developed in Office XP are not being prompted with a
    > Security Warning asking whether or not the expressions should be blocked or
    > not. I though that if you choose not to block them the first time you open
    > the db in 2003, it would remember this and not ask again for that db. My
    > question is how can I turn off the security warning message when the db is
    > opening? Please tell me that I don't have to redesign ALL of the hundreds of
    > db's I have out there that I programmed in XP????
    >
    > Thanks!
    > --
    > Thanks!
    > Jody
     
  4. jody frazier

    jody frazier
    Expand Collapse
    Guest

    Thanks! I have already split the db and made the front end into a MDE. Will
    I need to reconfigure all this again?
    --
    Thanks!
    Jody


    "Ofer Cohen" wrote:

    > Select in the menu bar :
    >
    > Tools > Macro > Security
    >
    > Set the security to Low
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "jody frazier" wrote:
    >
    > > I develop db in Access for my company (around 200 employees). I have
    > > developed quite a few db's in Office XP for several several employees over
    > > the past few years. My company recently just upgrading to Office 2003. So my
    > > existing db's that I developed in Office XP are not being prompted with a
    > > Security Warning asking whether or not the expressions should be blocked or
    > > not. I though that if you choose not to block them the first time you open
    > > the db in 2003, it would remember this and not ask again for that db. My
    > > question is how can I turn off the security warning message when the db is
    > > opening? Please tell me that I don't have to redesign ALL of the hundreds of
    > > db's I have out there that I programmed in XP????
    > >
    > > Thanks!
    > > --
    > > Thanks!
    > > Jody
     
  5. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    The set up it's for Access and not for the specific MDB/MDE.

    You can do that in different way
    Answer given by Jeff Conrad in prev post


    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/assista...ID=CH010411421033&CTT=4&Origin=CH010411391033

    Frequently asked questions about Access security warnings:
    http://office.microsoft.com/assista...ID=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


    --
    Good Luck
    BS"D


    "jody frazier" wrote:

    > Thanks! I have already split the db and made the front end into a MDE. Will
    > I need to reconfigure all this again?
    > --
    > Thanks!
    > Jody
    >
    >
    > "Ofer Cohen" wrote:
    >
    > > Select in the menu bar :
    > >
    > > Tools > Macro > Security
    > >
    > > Set the security to Low
    > >
    > > --
    > > Good Luck
    > > BS"D
    > >
    > >
    > > "jody frazier" wrote:
    > >
    > > > I develop db in Access for my company (around 200 employees). I have
    > > > developed quite a few db's in Office XP for several several employees over
    > > > the past few years. My company recently just upgrading to Office 2003. So my
    > > > existing db's that I developed in Office XP are not being prompted with a
    > > > Security Warning asking whether or not the expressions should be blocked or
    > > > not. I though that if you choose not to block them the first time you open
    > > > the db in 2003, it would remember this and not ask again for that db. My
    > > > question is how can I turn off the security warning message when the db is
    > > > opening? Please tell me that I don't have to redesign ALL of the hundreds of
    > > > db's I have out there that I programmed in XP????
    > > >
    > > > Thanks!
    > > > --
    > > > Thanks!
    > > > Jody
     
  6. jody frazier

    jody frazier
    Expand Collapse
    Guest

    So basically I'll need to change the security setting on EACH person's
    computer before running my databases?

    Thank you for your help!
    --
    Thanks!
    Jody


    "Ofer Cohen" wrote:

    > The set up it's for Access and not for the specific MDB/MDE.
    >
    > You can do that in different way
    > Answer given by Jeff Conrad in prev post
    >
    >
    > 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/assista...ID=CH010411421033&CTT=4&Origin=CH010411391033
    >
    > Frequently asked questions about Access security warnings:
    > http://office.microsoft.com/assista...ID=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
    >
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "jody frazier" wrote:
    >
    > > Thanks! I have already split the db and made the front end into a MDE. Will
    > > I need to reconfigure all this again?
    > > --
    > > Thanks!
    > > Jody
    > >
    > >
    > > "Ofer Cohen" wrote:
    > >
    > > > Select in the menu bar :
    > > >
    > > > Tools > Macro > Security
    > > >
    > > > Set the security to Low
    > > >
    > > > --
    > > > Good Luck
    > > > BS"D
    > > >
    > > >
    > > > "jody frazier" wrote:
    > > >
    > > > > I develop db in Access for my company (around 200 employees). I have
    > > > > developed quite a few db's in Office XP for several several employees over
    > > > > the past few years. My company recently just upgrading to Office 2003. So my
    > > > > existing db's that I developed in Office XP are not being prompted with a
    > > > > Security Warning asking whether or not the expressions should be blocked or
    > > > > not. I though that if you choose not to block them the first time you open
    > > > > the db in 2003, it would remember this and not ask again for that db. My
    > > > > question is how can I turn off the security warning message when the db is
    > > > > opening? Please tell me that I don't have to redesign ALL of the hundreds of
    > > > > db's I have out there that I programmed in XP????
    > > > >
    > > > > Thanks!
    > > > > --
    > > > > Thanks!
    > > > > Jody
     
  7. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Yes, you'll need to do that, but one of the solutions is to run code when the
    MDB is open that set the security setting, so you won't need to go from one
    PC to another.

    --
    Good Luck
    BS"D


    "jody frazier" wrote:

    > So basically I'll need to change the security setting on EACH person's
    > computer before running my databases?
    >
    > Thank you for your help!
    > --
    > Thanks!
    > Jody
    >
    >
    > "Ofer Cohen" wrote:
    >
    > > The set up it's for Access and not for the specific MDB/MDE.
    > >
    > > You can do that in different way
    > > Answer given by Jeff Conrad in prev post
    > >
    > >
    > > 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/assista...ID=CH010411421033&CTT=4&Origin=CH010411391033
    > >
    > > Frequently asked questions about Access security warnings:
    > > http://office.microsoft.com/assista...ID=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
    > >
    > >
    > > --
    > > Good Luck
    > > BS"D
    > >
    > >
    > > "jody frazier" wrote:
    > >
    > > > Thanks! I have already split the db and made the front end into a MDE. Will
    > > > I need to reconfigure all this again?
    > > > --
    > > > Thanks!
    > > > Jody
    > > >
    > > >
    > > > "Ofer Cohen" wrote:
    > > >
    > > > > Select in the menu bar :
    > > > >
    > > > > Tools > Macro > Security
    > > > >
    > > > > Set the security to Low
    > > > >
    > > > > --
    > > > > Good Luck
    > > > > BS"D
    > > > >
    > > > >
    > > > > "jody frazier" wrote:
    > > > >
    > > > > > I develop db in Access for my company (around 200 employees). I have
    > > > > > developed quite a few db's in Office XP for several several employees over
    > > > > > the past few years. My company recently just upgrading to Office 2003. So my
    > > > > > existing db's that I developed in Office XP are not being prompted with a
    > > > > > Security Warning asking whether or not the expressions should be blocked or
    > > > > > not. I though that if you choose not to block them the first time you open
    > > > > > the db in 2003, it would remember this and not ask again for that db. My
    > > > > > question is how can I turn off the security warning message when the db is
    > > > > > opening? Please tell me that I don't have to redesign ALL of the hundreds of
    > > > > > db's I have out there that I programmed in XP????
    > > > > >
    > > > > > Thanks!
    > > > > > --
    > > > > > Thanks!
    > > > > > Jody
     

Share This Page