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

How can I allow multiple users to edit a shared database?

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

  1. CarlaInJax

    CarlaInJax
    Expand Collapse
    Guest

    We have an Access database that needs to be edited by several users.
    Currently, only one person can access at a time to input information. Can
    several users access the database and input information simultaneously? I
    have an Excel spreadsheet that will do this, but cannot find out how to do it
    in Access.
     
  2. Loading...

    Similar Threads Forum Date
    Are Sikhs Allowed To Fish? Hard Talk Aug 28, 2016
    Sikh News Allow Turbaned Sikh Basketball Players: US Lawmakers - Chandigarh Tribune Breaking News Aug 4, 2016
    Hard Talk Taking One Liners Out Of Context From Gurbani To Allow Intellectual Independence? Hard Talk Apr 23, 2016
    Rehras at Halloween Blogs Oct 31, 2015
    Sikhi allows Worshiping of only Akaal or all the Gurus??? Questions and Answers May 1, 2015

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    CarlaInJax wrote:
    > We have an Access database that needs to be edited by several users.
    > Currently, only one person can access at a time to input information.
    > Can several users access the database and input information
    > simultaneously? I have an Excel spreadsheet that will do this, but
    > cannot find out how to do it in Access.


    Access by default allows shared use. You don't need to do anything.

    However there are a few things to consider. First Access performs
    multi-user tasks best when it is split, with all the data in one MDB on the
    server and separate MDBs for each user on their own machine. Their MDBs
    will have their own forms, queries reports etc.

    Second if you have more than one person editing at the same time,
    something needs to keep them from stepping on one another's toes. That is I
    may make a change and you may be editing the same record at the same time
    may not see that change and make another inappropriate change to the same
    record. Access employs record locking as the traffic cop. Do some research
    on record locking as it is a complex subject. Note, that in some versions
    of Access not just the one record someone is editing is locked, but
    sometimes more than one record may be locked.

    --
    Joseph Meehan

    Dia duit
     
  4. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Check this link about "Splitting a Microsoft Access Database", essential to
    make the database a accesable by more then one user

    http://www.databasedev.co.uk/split_a_database.html

    --
    Good Luck
    BS"D


    "CarlaInJax" wrote:

    > We have an Access database that needs to be edited by several users.
    > Currently, only one person can access at a time to input information. Can
    > several users access the database and input information simultaneously? I
    > have an Excel spreadsheet that will do this, but cannot find out how to do it
    > in Access.
    >
     
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