Go to Top
  • No products in the cart.

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

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

About Juan Soto

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 Responses to "Windows 7 64bit Slow with Access 2007 – Solved!"

  • Jonas
    June 4, 2015 - 7:57 pm Reply

    This worked like a charm for Access 2013!!

    Thank you so much!

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

      Good to hear!

  • Afton GIlle
    September 15, 2014 - 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!”

  • Sean
    February 29, 2012 - 9:25 am Reply

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

  • Aziz
    December 22, 2011 - 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 ?

  • DeJa
    December 15, 2011 - 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.

  • Anonymous
    November 15, 2011 - 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.

  • Isaac Richter
    November 2, 2011 - 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 - 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 Reply

Your email address will not be published. Required fields are marked *