Welcome to SPN

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

Sign Up Now!

Speed of a network Access database

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

  1. Alylia

    Alylia
    Expand Collapse
    Guest

    Hello,

    I have a split database on the network drive but is being accessed by users
    through the front end database that is also on the network but has a copy is
    installed on the local terminals of users. I have noticed that whenever, more
    than one user is concurrently accessing their version of the front end
    database, the response time becomes disturbing slow.

    Please advice on what needs to be done.

    Al
     
  2. Loading...

    Similar Threads Forum Date
    Leisure Speedy Singhs Business, Lifestyle & Leisure Aug 24, 2011
    General Spectacles of Speed Painting Videos Jul 20, 2011
    Sikh News Speed-faithing shows diversity of campus religious traditions Breaking News Apr 20, 2010
    Sikh News With 1.1 mn pending cases, Punjab and Haryana court moves for speedier trials (IANS v Breaking News Apr 22, 2008
    Sikh News With 1.1 mn pending cases, Punjab and Haryana court moves for speedier trials (Calcut Breaking News Apr 22, 2008

  3. tina

    tina
    Expand Collapse
    Guest

    have a look at the following webpage:
    http://www.granite.ab.ca/access/performancefaq.htm

    hth


    "Alylia" <Alylia@discussions.microsoft.com> wrote in message
    news:564C8672-2A62-408E-8209-C0F3B76633E9@microsoft.com...
    > Hello,
    >
    > I have a split database on the network drive but is being accessed by

    users
    > through the front end database that is also on the network but has a copy

    is
    > installed on the local terminals of users. I have noticed that whenever,

    more
    > than one user is concurrently accessing their version of the front end
    > database, the response time becomes disturbing slow.
    >
    > Please advice on what needs to be done.
    >
    > Al
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Do not share the front-end from the network. Each user needs to run the
    front-end from his/her own workstation, linked to the data on the back-end
    network. The method you are using now is not only slower, but it invites
    corruption.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Alylia" <Alylia@discussions.microsoft.com> wrote in message
    news:564C8672-2A62-408E-8209-C0F3B76633E9@microsoft.com...
    > Hello,
    >
    > I have a split database on the network drive but is being accessed by
    > users
    > through the front end database that is also on the network but has a copy
    > is
    > installed on the local terminals of users. I have noticed that whenever,
    > more
    > than one user is concurrently accessing their version of the front end
    > database, the response time becomes disturbing slow.
    >
    > Please advice on what needs to be done.
    >
    > Al
     
  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Arvin Meyer [MVP]" <a@m.com> wrote:

    >Do not share the front-end from the network. Each user needs to run the
    >front-end from his/her own workstation, linked to the data on the back-end
    >network. The method you are using now is not only slower, but it invites
    >corruption.


    Minor quibble. While it's not optimal you can sun each users front
    end from the server. Mind you each person must have their own copy
    of the FE.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  6. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    "Tony Toews" <ttoews@telusplanet.net> wrote in message
    news:9el672hjauac6tnnjb73n5c1d0evtrfe3m@4ax.com...
    > "Arvin Meyer [MVP]" <a@m.com> wrote:
    >
    > >Do not share the front-end from the network. Each user needs to run the
    > >front-end from his/her own workstation, linked to the data on the

    back-end
    > >network. The method you are using now is not only slower, but it invites
    > >corruption.

    >
    > Minor quibble. While it's not optimal you can sun each users front
    > end from the server. Mind you each person must have their own copy
    > of the FE.


    Yep. No quibble at all. The keyword is "share". In fact, running individual
    copies from a server is the method of choice for a Terminal Server.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access
     

Share This Page