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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9853-slow-access-database-on-a-network.html
seems to crawl. Iâ€™ve added gig nics and Iâ€™m planning to add a scsi drive to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9853
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 (**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
pleaseNOOSpamKallal@msn.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9853
http://www.members.shaw.ca/AlbertKallal