security

Discussion in 'Access Security' started by Jackie, May 20, 2010.

  1. Jackie

    Jackie Guest

    I created a database in Access 2007 and need to move it to a common drive.
    This information needs to be accessible for everyone who has the drive to
    view the contents. How do I secure the database so that only 2 of us can
    make changes or add to the database while everyone else can only view it?
    Many thanks. Jackie
     
    Jackie, May 20, 2010
    #1
    1. Advertisements

  2. First of all you need to split the database so that only the data in the
    tables is on the common drive. Failure to do that and sharing forms, etc.
    will result in corruption After you have split the database, put a copy of
    the front-end (everything nut the tables) linked to the data tables on the
    common drive, on each user's workstation.

    Now to get to your question: What you are asking for is User-Level Security.
    The new ACCDB file format does not support that. If you are using that
    format, convert it to an MDB to get that functionality: Here are some
    articles to read to help you secure properly:

    Security FAQ
    http://support.microsoft.com/support/access/content/secfaq.asp

    Lynn Trapp's summarization:
    http://www.ltcomputerdesigns.com/The10Steps.htm

    KB articles:
    http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
    http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
    http://support.microsoft.com/default.aspx?kbid=325261

    Joan Wild's articles:
    http://www.jmwild.com/security02.htm
    http://www.jmwild.com/security97.htm
    http://www.jmwild.com/SecureNoLogin.htm
    http://www.jmwild.com/Unsecure.htm
    --
    Arvin Meyer, MCP, MVP
    http://www.datastrat.com
    http://www.accessmvp.com
    http://www.mvps.org/access
    Co-author: "Access 2010 Solutions", published by Wiley
     
    Arvin Meyer [MVP], May 21, 2010
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.