Windows 7 64bit Slow with Access 2007 – Solved!

A while back I talked about a problem one of my clients was having with Windows 7 64 bit and Access 2010/2007. It was terribly slow and unacceptable. You can see the original post here.

Solution Found – Turn off the LLMNR Protocol

ADVERTISING
SQL Server Hosting

My client waited long and hard to get this resolved, but Microsoft did come through for him. The solution is to disable the LLMNR protocol using the Group Policy Editor:

Go to Search – Type GPEdit.msc – Press Enter – Navigate to the following and make sure Enabled is checked –

Computer ConfigurationAdministrative TemplatesNetworkDNS Client

Turn off Multicast Name Resolution = Enabled

You can read more about it here:

http://social.msdn.microsoft.com/Forums/en/windowscompatibility/thread/f295994c-5812-4e46-8ac9-f05471d4dd54

2017-02-06T22:01:01+00:00

About the Author:

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

9 Comments

  1. Jonas June 4, 2015 at 7:57 pm - Reply

    This worked like a charm for Access 2013!!

    Thank you so much!

    • Juan Soto June 4, 2015 at 9:01 pm - Reply

      Good to hear!

  2. Afton GIlle September 15, 2014 at 8:18 pm - Reply

    Really, you claim there is a fix for the slow Access then in the end you state: “Leaving LLMNR disabled in a Domain environment can cause issues with connectivity. In this case, a Networking engineer will be able to assist by capturing a Netmon trace and making changes in the IPV6 properties, rather than leaving LLMNR disabled.” So we are all back to square one. There is no fix for this problem. MS Access 2010 is slow! I have a solution, “Don’t use Access 2010!”

  3. Sean February 29, 2012 at 9:25 am - Reply

    Worked a treat! took a long time flicking between records before.. Thanks so much!

  4. Aziz December 22, 2011 at 3:47 pm - Reply

    Hello
    I designed a database by Access 2011 for sale and purchase , but did not work on Windows 7 64.
    What is the solution Please ?

  5. DeJa December 15, 2011 at 8:35 pm - Reply

    Unfortunately it doesn’t solve our problems. Our applications still working with an Access 97 Database (via DAO) and our customers still have these enormous problems with Windows 7. Especially when tables have many columns and records, it is very disadvantageous.

  6. Anonymous November 15, 2011 at 11:37 am - Reply

    Didnt do the trick for me.

    interestingly running the database locally on a Win7 still results in very poor performance.

    even a low spec winXP machine accessing the database across the network is faster than opening it locally on a Win7 machine.

    So my issue with Win7 and access 2007 doesnt seem to be network based.

    Still searching for a solution, but thanks for the suggestion.

  7. Isaac Richter November 2, 2011 at 11:38 pm - Reply

    Does this only apply to users running SQL Server for their back end of Access FE/BE setups as well?

    • Juan Soto November 2, 2011 at 11:40 pm - Reply

      Yes if they are also running Windows 7 64 bit OS.I have received additional comments from Microsoft:
      “Leaving LLMNR disabled in a Domain environment can cause issues with connectivity. In this case, a Networking engineer will be able to assist by capturing a Netmon trace and making changes in the IPV6 properties, rather than leaving LLMNR disabled.”

      Are you running a domain at your firm?

      Thanks
      Juan

Leave A Comment

 

Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.