PC Review


Reply
Thread Tools Rate Thread

Access 2007 Weird Slowness

 
 
jjsolo
Guest
Posts: n/a
 
      4th Jan 2010
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
 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      4th Jan 2010
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.

"jjsolo" <(E-Mail Removed)> wrote in message
news:A29F5320-1804-4EEA-BFA2-(E-Mail Removed)...
> 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



 
Reply With Quote
 
Paul Shapiro
Guest
Posts: n/a
 
      5th Jan 2010
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.

"Jeff Boyce" <(E-Mail Removed)> wrote in message
news:eS$(E-Mail Removed)...
> 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.
>
> "jjsolo" <(E-Mail Removed)> wrote in message
> news:A29F5320-1804-4EEA-BFA2-(E-Mail Removed)...
>> 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.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
weird listbox behavior - just upgraded to Access 2007 Sean Kelly Microsoft Access Forms 1 10th Oct 2009 06:13 AM
Is there a fix for the slowness in excel 2007? excelfrustrated Microsoft Excel Misc 7 7th Jul 2008 05:08 PM
Access 2007 linked table acting weird Beginner Microsoft Access 2 22nd May 2008 04:38 AM
Outlook 2007 Slowness Problem Andy Microsoft Outlook Discussion 10 20th Feb 2007 08:12 PM
Outlook 2007 slowness JOHN RUFF Microsoft Outlook 5 15th Dec 2006 09:07 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:00 PM.