Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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?
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page