Welcome to SPN

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

Sign Up Now!

Slow Access Database on a network

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

  1. Zaporteza

    Zaporteza
    Expand Collapse
    Guest

    Unfortunately I inherited a Microsoft access database that runs on an windows
    xp machine. It is shared between four users. When the users are attached it
    seems to crawl. I’ve added gig nics and I’m planning to add a scsi drive to
    the xp machine that houses the database. Is there anything else I could do
    to speed it up or am I spinning my wheels?
     
  2. Loading...

    Similar Threads Forum Date
    Opinion IDEAS: Revolution, Evolution Or Slow Death Sikh Sikhi Sikhism Jul 16, 2016
    Slow metabolism 'obesity excuse' true Health & Nutrition Oct 26, 2013
    India India in the Slow Lane Breaking News Feb 10, 2013
    USA Slow Recovery at US Sikh Temple Breaking News Jan 14, 2013
    UK Archbishop of Canterbury Visits Hounslow Sikh Temple Breaking News Oct 19, 2011

  3. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    Throwing more hardware beyond a properly running 100 base T network will
    generally not help.

    However, ensuring you have a proper setup for multi-user will make a big
    difference.

    You should have a split system, so, get that right....

    I explain this here:
    http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

    The above will not fix your performance, but it will increase reliability by
    a large amount.

    To fix performance, try the persistent connection trick...9 out of 10 times,
    this will solve your speed problems

    For the persistent connection trick, and more ideas..work you way though the
    following list...it should fix your
    performance issues

    http://www.granite.ab.ca/access/performancefaq.htm


    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     

Share This Page