Access 2003 Slow on windows Vista and Window 7

We are currently Running SQL Server 2000 on a Windows Server 2003 server.  We use Access 2003 as a front end.  We have used Windows XP systems for the last 6 years and everything was running fine.  Except now that we bought two new systems (Windows 7) , access runs slow.  It it would take 1 seconds to to open a form on a Windows XP system, it takes almost 10 seconds to do it on Windows 7.  I also tested it on a Windows Vista system, and the same problem occurs.

Has anyone had this issue?

Thanks,
mfsrulesAsked:
Who is Participating?
 
als315Connect With a Mentor Commented:
Read this thread:
http://social.msdn.microsoft.com/Forums/en/windowscompatibility/thread/f295994c-5812-4e46-8ac9-f05471d4dd54
There are two recommended solutions:
1. Add your server name to hosts file to prevent use of Windows Vista and 7 LLMNR protocol
2. Disable TCP autotuning
0
 
mfsrulesAuthor Commented:
Yes.  That was one of the main issues.  By disabling LLMNR the speed has improved dramatically.  XP systems are still a little bit faster though.   If you don't want to read through the thread just follow these steps to disable the LLMNR protocol:

Modify Group Policy – Go to Search – Type GPEdit.msc – Enter – Navigate to the following and make sure Enabled is checked -

Computer Configuration\Administrative Templates\Network\DNS Client
\Turn off Multicast Name Resolution = Enabled

Thank you for your help and hope this helps other people who might be having the same issue.


***Update.  Windows 7 32 bit seems to work faster than the 64 bit version.  Also Windows 8 is slower than Windows 7
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.