locked
Access 2007 very slow on Windows 7 RRS feed

  • Question

  • Access 2007 is running very slowly in on two new Windows 7 clients.  I cannot find any information that addresses the issue.

    We have been running Windows XP SP3 clients successfully for almost a year.  The speed is virtually instantaneous.  The Access file is hosted on a file server, Windows Server 2003, with SQL Server Express 2008.  Nothing has changed on the server.  The Windows XP clients previously and currently experience no problems.

    The first of 2 new computers were deployed with Windows 7, with OS pre-loaded from Dell.  Microsoft update was run to update OS and Access.  Once discovered that Access was running brutally slow, I used the other new PC to test.  Windows 7 freshly installed.  Office 2007 freshly installed.  Tested - still slow.  Ran Windows Update, then re-tested.  Still slow.

    The issue reminds me of the slowness experienced when we were developing the Access database on my laptop which was running Vista.

    I'm convinced the problem is a conflict with Windows on the client, but cannot pinpoint it.  I've searched these forums and Google for answers, but have not found any information that has specifically addressed this issue.  Can anyone offer assistance?

    Monday, January 31, 2011 4:00 PM

Answers

All replies

  • What is slow? Can you please run ProcessMonitor [1] in background while using Access? Stop the Process Monitor trace [2] and configure Process Monitor to use the public MS symbols. Now look what takes most time (look at the duration column).

    André

    [1] http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx
    [2] http://blogs.msdn.com/b/dswl/archive/2010/01/10/how-to-capture-a-process-monitor-trace.aspx


    "A programmer is just a tool which converts caffeine into code" CLIP- Stellvertreter http://www.winvistaside.de/
    Monday, January 31, 2011 10:06 PM
  • Andre,

    Thank you for the response.

    By slow, I mean the response time within Access - moving from screen to screen is dreadfully slow, taking 30+ seconds on Windows 7 to to what a computer with Windows XP will do in 1 second.

    I ran the Process Monitor and only 3 items lasted more than a fraction of a second.  All three were SearchIndexer.exe, ranging from 1.74 to 2.27 (seconds, I assume).  Nothing seems out of the ordinary (to me).

     

    Tuesday, February 1, 2011 4:24 PM
  • ok, stop the Windows Search service or exclude the folder where your Access databases are located from being indexed. Does this make a difference?

    "A programmer is just a tool which converts caffeine into code" CLIP- Stellvertreter http://www.winvistaside.de/
    Tuesday, February 1, 2011 7:25 PM
  • I stopped the Windows Search Service and tried again.  The results were the same.
    Wednesday, February 2, 2011 3:59 PM
  • hmm, I have no idea. Ask the Users in the Office Forum:

    http://social.technet.microsoft.com/Forums/en-US/category/officeitpro

    I'm not an Expert for Access questions.


    "A programmer is just a tool which converts caffeine into code" CLIP- Stellvertreter http://www.winvistaside.de/
    • Marked as answer by Juke Chou Monday, February 14, 2011 9:25 AM
    Wednesday, February 2, 2011 8:11 PM
  • THIS IS A HUGE PROBLEM FOR ME AS WELL.

    HAS ANYONE FOUND A SOLUTION?

    ACCESS USED TO BE A GREAT QUICK FIX PROGRAM, NOW IT IS A DOG!

    Monday, December 2, 2013 4:16 PM