Access Network Slowness

[Brossyg]

I have a 250meg Access db running on Access 2003 on WinXPPro. The db is
hosted on one very fast PC and two other very fast PCs also use the db
through a gigabit network. As the database has grown (frequently compacted),
certain db functions like forms and reports have crawled to a halt on the PCs
that are not the host. The user of the host PC still gets pretty fast
performance. Splitting the database made no difference. The only protocol
installed in TCP/IP. Is there any way to speed up the network performance of
the db?

 

[Jerry Whittle, Microsoft Access MVP]

By splitting, do you mean that you put a copy of the FE on each user's
computer?

Peer-to-Peer networks are slow. Put the BE on a dedicated server if you feel
then need for speed.

Also try disabling the virus checkers on the slow computers for a short
test. Most virus scanner will allow you to exclude scaning on .md? files.

 

[Tony Toews [MVP]]

Jerry Whittle, Microsoft Access MVP

Peer-to-Peer networks are slow. Put the BE on a dedicated server if you feel
then need for speed.

I'm not at all sure I'm going to agree with this statement in all
situations. If that PC is lightly used then what's the problem?

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/