Access 2007 Weird Slowness

[jjsolo]

We have recently upgraded our PC's from Windows XP and Office 2003 to Windows
Vista and Office 2007.

A bunch of our Office Access 2003 Applications are showing a wierd behavior
when run with Access 2007. When a user is in a form input text field and
they start typing sometimes it takes about 4 seconds for the characters to be
displayed in the text box. This happens many time during the day and is such
a nuisance that we have had to allow users to go back and use Access 2003
thru a Citrix solution.

While investigating the issue the one thing I noticed was that while in any
one of the forms for any of the applications we have if I just sat there and
did no typing or anything on the PC I could see Network spikes occurring
using the task manager even though I was not doing anything. I would then
try to type in a text box, but the keystrokes would not be displayed for a
few seconds. After a couple of minutes the netork spikes would go away and I
would be able to type in the text box again. This would happen every 15
minutes or so.

The users you see this problem are on a slower 10Mbps network, but we did
not see this with Access 2003.

Any help would be appreciated.

Thanks,

Joseph Solonika

 

[Jeff Boyce]

Any chance your network is using an antivirus product ... that had its
definitions updated recently?

I saw a similar performance slump that turned out to be due to how the
"upgraded" network antiviral was treating calls from the front-end to the
back-end.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Paul Shapiro]

Vista has network "optimizations" which work very well when the client and
server both have relatively recent network drivers, but can perform very
poorly with older network drivers. It could be that these optimizations are
counter-productive on an older 10 mbit network, since the optimizations
assume reasonably modern switches.

You can disable these "enhancements" to see if it makes a difference. I
don't remember the exact syntax but you can look for commands like this:
netsh int tcp show global
and
netsh int tcp set global

The parameters of interest are receive-side scaling and chimney offload.