Welcome to SPN

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

Sign Up Now!

Multiple Users

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

Tags:
  1. Pizza

    Pizza
    Expand Collapse
    Guest

    I currently building a db for a group of 10 users. How would access perform
    with 10 users using the db at the same time?
     
  2. Loading...


  3. Glen T

    Glen T
    Expand Collapse
    Guest

    I have created a database which is currently used by 10 -15 people at
    the same time on the server in my office. I have had very little
    trouble. Problems will likely surface though if multiple people try to
    update the same record at the exact same time so you have to be careful
    for that.
     
  4. Pizza

    Pizza
    Expand Collapse
    Guest

    What changes did you make to prevent that?

    "Glen T" wrote:

    > I have created a database which is currently used by 10 -15 people at
    > the same time on the server in my office. I have had very little
    > trouble. Problems will likely surface though if multiple people try to
    > update the same record at the exact same time so you have to be careful
    > for that.
    >
    >
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Your application should be split into a front-end (containing the queries,
    forms, reports, macros and modules), linked to a back-end (containing the
    tables and relationships). Only the back-end should be on the server: each
    user should have his/her own copy of the front-end, preferably on his/her
    hard drive.

    Read what Tony Toews has to say about this subject at
    http://www.granite.ab.ca/access/splitapp/index.htm

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Pizza" <Pizza@discussions.microsoft.com> wrote in message
    news:A8307EF6-5555-4E8D-848A-7D41FCD466BA@microsoft.com...
    > I currently building a db for a group of 10 users. How would access

    perform
    > with 10 users using the db at the same time?
     
  6. Glen T

    Glen T
    Expand Collapse
    Guest

    Sorry for the late reply Pizza. I have been in meetings most of the
    day. I had the DB set up just as Douglas has specified. I didn;t want
    to have users working directly in the tables so I created a front end
    and a back end. Obviously, the front end used a bunch of queries and
    forms to update the records and create reports.
     

Share This Page