none
Access Front End Slow When On Windows Server 2003 RRS feed

  • Question

  • Hi,

    We are in the process of implementing terminal services on Windows 2003 Server. One of the things that will be used with terminal services is an Access 2003 database linked to a SQL Server 2005 database that runs on a different Windows 2003 Server.

    The driver used is the SQL Server 2005 native client, not sure if relevant. Prior to activating Terminal Services we tested the Access 2003 FE on the Windows 2003 Server that will be used with Terminal Services. It ran very slow by a factor of 10 or more compared to when being run on an XP box for forms with multiple list views and sub forms.

    The Access 2003 FE performance is fine when used on a Windows XP box and connecting to the same SQL Server 2005 database.

    Any ideas why? I did see this http://www.tek-tips.com/viewthread.cfm?qid=1086592&page=1

    By the way the Windows 2003 Server is fully service packed.

    Thanks,

    Will

    • Moved by Mike Dos Zhang Friday, January 21, 2011 8:24 AM i think this is not a winForm problem (From:Windows Forms General)
    Tuesday, January 18, 2011 11:44 AM

Answers