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 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.

Posted in Access Help
6 comments on “Windows 7 64bit Slow with Access 2007 – Solved!
  1. Sean says:

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

  2. Aziz says:

    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 ?

  3. DeJa says:

    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.

  4. Anonymous says:

    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.

  5. Isaac Richter says:

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

    • Juan Soto says:

      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

Free email subscription

Enter your email address:


Facebook

Twitter

Blog Archives

ITImpact
%d bloggers like this: