Welcome to SPN

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

Sign Up Now!

building multiuser databases

Discussion in 'Information Technology' started by s@mailinator.com, Jul 28, 2006.

  1. s@mailinator.com

    s@mailinator.com
    Expand Collapse
    Guest

    I need to develop a multiuser database application to be used by four
    people(The number of users are not likely to increase). It is for
    storing records of different versions of particular papers. I am new to

    building such an application. I would like to know what would the
    requirements be for using Access as the means for building the
    multiuser database. Two of the four use Access 2000(running Windows 98)

    and other two use Access 2003(running Windows 2000). Can any one
    machine serve as server to host all queries from the users or do I need

    another machine to act as the server for the queries(if so please let
    me know what OS should it use).

    I would appreciate any advice and guidance regarding building such a
    system.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh Some Bridge Building Sikh Sikhi Sikhism May 10, 2016
    Interfaith Building A Sikh Paradigm For Interfaith Work: Part 2 Interfaith Dialogues Apr 29, 2016
    USA Houston Sikh woman’s rights possibly violated by ban on Kirpans in IRS building Breaking News Nov 22, 2013
    India Cash crunch: Punjab to mortgage buildings Breaking News Aug 25, 2013
    India Deadly Building Collapse near Mumbai Breaking News Apr 5, 2013

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    s@mailinator.com wrote:
    > I need to develop a multiuser database application to be used by four
    > people(The number of users are not likely to increase). It is for
    > storing records of different versions of particular papers. I am new
    > to
    >
    > building such an application. I would like to know what would the
    > requirements be for using Access as the means for building the
    > multiuser database. Two of the four use Access 2000(running Windows
    > 98)
    >
    > and other two use Access 2003(running Windows 2000). Can any one
    > machine serve as server to host all queries from the users or do I
    > need
    >
    > another machine to act as the server for the queries(if so please let
    > me know what OS should it use).
    >
    > I would appreciate any advice and guidance regarding building such a
    > system.


    Access itself should not have a problem. You should split the database
    so that the data is on the "server" and each user has their own front end
    that holds the forms reports etc.

    I suspect that you may have problems however. You did not say what kind
    of network you are using, but I am going to guess that it is not a typical
    high end professional network. Access does require a very robust network or
    it may experience problems. That machine with Windows 98 is a good
    indication of the problem.


    --
    Joseph Meehan

    Dia duit
     
  4. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Access is multi-user capable out of the box.

    Split the application into the shared data store (one mdb containing just
    the tables), and the application (another mdb containing all other
    components, with linked tables.) If that is a new concept, see:
    http://allenbrowne.com/ser-01.html

    The data mdb can reside in any folder that is fully shared for all users
    (read, write, and delete privileges). It can be one of the workstations, or
    a dedicated server if you prefer.

    Naturally you will use the Access 2000 file format so both versions can
    understand it.

    To ensure good performance, follow the suggestions in this article:
    http://www.granite.ab.ca/access/performancefaq.htm

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    <s@mailinator.com> wrote in message
    news:1147568092.281334.32930@u72g2000cwu.googlegroups.com...
    >I need to develop a multiuser database application to be used by four
    > people(The number of users are not likely to increase). It is for
    > storing records of different versions of particular papers. I am new to
    >
    > building such an application. I would like to know what would the
    > requirements be for using Access as the means for building the
    > multiuser database. Two of the four use Access 2000(running Windows 98)
    >
    > and other two use Access 2003(running Windows 2000). Can any one
    > machine serve as server to host all queries from the users or do I need
    >
    > another machine to act as the server for the queries(if so please let
    > me know what OS should it use).
    >
    > I would appreciate any advice and guidance regarding building such a
    > system.
     

Share This Page