Slow Access Database on a network

#1 (**permalink**) 28-Jul-2006, 08:07 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9853-slow-access-database-on-a-network.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9853
to speed it up or am I spinning my wheels?

*

#2 (**permalink**) 28-Jul-2006, 08:07 AM

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/AlbertKal...plit/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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9853

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9853
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal