Welcome to SPN

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

Sign Up Now!

Access 2003 database copied and pasted

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

  1. Kira

    Kira
    Expand Collapse
    Guest

    I need to have a copy of my Access 2003 DB on the shared drive at our office.
    Coworkers must have access to my records, but I don't want them to be able to
    alter my records.

    I thought by copying and pasting my DB, it would create a separate DB and if
    they changed something, it wouldn't affect me. But, they are linked and any
    change they make appears in my DB and vice versa. I tried locking (read-only)
    the copy on the shared rive, but it locks mine as well.

    I simply right-clicked on my DB file, copied it and then pasted it onto the
    shared drive. Is there a way to put a separate copy on this drive?
     
  2. Loading...


  3. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    If they are truly connecting to a copy of the file, it should have no affect
    on your file provided your file is a stand-alone file. If your file is split
    into a front-end/back-end setup then the front-end you copied to the share
    will still be connected to the back-end, provided the path is recognizable
    from the other computer. In that case, yes, they will change the data in the
    back-end file that you're using.

    The best way to do what you're asking would be to split the database into a
    front-end/back-end if it isn't already and use Access Security to give them
    read-only permissions to the back-end file. The back-end would contain only
    the data tables everything else would be in the front-end file with linked
    tables to the back-end file. Each user would get their own front-end file.
    This will let the users see the current data as you edit it.

    For more information on doing this, see these links.
    http://www.granite.ab.ca/access/splitapp/index.htm
    http://support.microsoft.com/kb/289885/en-us

    --
    Wayne Morgan
    MS Access MVP


    "Kira" <knarlee at yahoo dot com(donotspam)> wrote in message
    news:326848F9-FA50-4506-91EE-393696CDCFDB@microsoft.com...
    >I need to have a copy of my Access 2003 DB on the shared drive at our
    >office.
    > Coworkers must have access to my records, but I don't want them to be able
    > to
    > alter my records.
    >
    > I thought by copying and pasting my DB, it would create a separate DB and
    > if
    > they changed something, it wouldn't affect me. But, they are linked and
    > any
    > change they make appears in my DB and vice versa. I tried locking
    > (read-only)
    > the copy on the shared rive, but it locks mine as well.
    >
    > I simply right-clicked on my DB file, copied it and then pasted it onto
    > the
    > shared drive. Is there a way to put a separate copy on this drive?
     

Share This Page