MS Access database runs extremely slow on Citrix Presentation Server
Posted on 2007-08-09
Config A (The configuration that works): HP Proliant DL360; Windows 2000 SP4; Citrix Metaframe XP Server; Microsoft Access 2000 SP3.
Config B (The configuration that doesn't work): HP Proliant DL380 G3; Windows 2003 SP1; Citrix Presentation Server 3; Microsoft Access 2003.
Issue: We have an Access 2003 database (.mdb file) housed on a Windows 2003 server separate from the two servers listed above. Our Citrix clients, running Windows XP, are are both local and remote. On Config A, when the Citrix client launches the .mdb file, the response time ranges anywhere between 15 seconds to 3 minutes as compared to approximately 5 seconds on Config B. clients on Config A access the .mdb file via the Citrix Program Neighborhood. clients on Config B access it through the citrix web front end using I.E. 6.0 SP2. The Config A, Config B and the .mdb host file servers are on the same subnet and are in the same physical location.
Does anyone know what could be causing the latency issues with the Access db on the Citrix Presentation Server and how to resolve it?