[Last Call] Learn how to a build a cloud-first strategyRegister Now


MS Access database runs extremely slow on Citrix Presentation Server

Posted on 2007-08-09
Medium Priority
Last Modified: 2008-08-23
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?
Question by:76133
  • 3
  • 2
LVL 39

Expert Comment

ID: 19665775
Some general considerations to look at:

Reduce Corruption, Speed up database
All databases are heavy network users. To reduce the risk of corruption and speed up the database, these are things to do for any database:

1: Make sure your hardware is in top shape, all computers are routinely vacuumed to remove dust and lint and your network is set up correctly. Have all the machines on the same domain.

2: Have individual front ends on each machine. I created a database that checks the server for a newer copy of the front end, downloads it if needed, then runs it. You can get a copy of it at: http://www.thenelson.name/, Updated Front End

3: Create a mapped drive for the backend or place the backend folder as close to the root folder and use only UNC path to the backend. Some people (and Microsoft) say the mapped drive is better, some say the UNC path is better. I have found it depends on the network setup.

4: Have the name of the backend and the name of the folders in the UNC path to it as short as possible meeting dos 8.3 naming specs and with only alpha numeric characters. \\server1\C:\db\db1_be.mdb is better than \\Database Server 601\C:\My Database Folder\Database Backends\My Database Backend_be.mdb

5: Don't run a local copy of the front end on the machine that has the backend -- best to have the backend on a true server running a domain with all workstations subscribed to the domain. You might get by running home version for two computers, maybe three sharing a very small, simple Access database on the home version although you may run into sharing problems. In a work situation, running a multi user Access database, all workstations should be running the pro version. It you have less than about five workstations, you might get away with the backend being on a system running pro but more than that or with a complicated database, you need a domain and the sever running a sever OS. Get up to a dozen heavy users or a couple of dozen light users and the server should be a true server, be dedicated to only serving the one database and the back end should be SQL Server (or SQL Server Express).

All of this is cutting down the number of times accesses need to be qualified, files need to be opened and closed and reduces the complexity of parsing the path all of which reduces the chance of corruption and speed up the database.

Author Comment

ID: 19673238
Thanks very much for your feedback. Youve listed very good actionable measures to reduce corruption and help database response times.  However, since we are using Citrix, the MS Access application is installed on the Citrix server itself.  Therefore, (and please correct me if Im wrong) we cannot have the individual front ends on each machine.  

Also, I failed to mention on the previous post that when Citrix clients launch the .MDB file (regardless if they go through the Citrix Program Neighborhood or through the Citrix web front end), they are actually launching a shortcut to an .MDB file located on a different server, which in turn calls the SQL backend tables located on yet another different server.  In other words, we are talking about 4 hops here:  client to Citrix to .MDB host server to SQL server.  This setup works fine on the Config A server though.  In addition, we have other non-Access applications on the Config B server that are not experiencing this lag time.

Any thoughts on what could be causing the latency issues with the Access db?
LVL 39

Accepted Solution

thenelson earned 2000 total points
ID: 19674585
I'm not familiar with Citrix.  Did you talk with their tech support?

BTW: Did you get A and B reversed in:
"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."?

Author Comment

ID: 19685999
Doh!!!  Yes, you are correct, I did get Config A and Config B mixed up on my original post.  I will be contacting Citrix with this issue.  I wanted to make sure that this was not a known issue with MS Access databases and Citrix.  Speaking with their Tech Support appears to be the way to go and the solution this time.  I will assign the points to you.  Thank you for your assistance with this matter.
LVL 39

Expert Comment

ID: 19686464
Hopefully tech support will know more about their product than you do.  I find Asking for a supervisor or for the question to be escalated helps if they are not helpful.  After that, I find a fax from an attorney usually gets me a very knowledgeable person almost immediately.  (I am a number of Prepaid legal so those letters are part of my benefits.)

You're welcome.  Glad to help and thank you very much for the points with "A" grade!

Happy Computing!


Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question