Solved

Access 2003 Running Slow on Windows 2008 Terminal Server

Posted on 2011-02-23
6
1,000 Views
Last Modified: 2012-05-11
Hi - We have been operating remote desktop over our LAN in administrative mode running a MsAccess application and have now changed to application mode with a new Terminal server running windows 2008 R2 Enterprise. The problem is when we open a MsAccess application on the 2008 terminal server it runs extremely slow only on request. It's the same if the database is on a File Server and Msaccess.exe is on a TSE Server
When I remote into the, 2003 server in TSE mode or on a local PC Windows XP, and open the same Access application it runs fine.
It seems that relation and index don't operate

0
Comment
Question by:patrickgermain
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 58
ID: 34970069

 Is this a multi-core processor server and/or 64 bit?

JimD.
0
 

Author Comment

by:patrickgermain
ID: 34971730
it's a Bi processor 64 bits

Patrick
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 34972457
Take a read through the following thread:

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Remote_Desktop-Terminal_Services/Q_25091616.html

 and specifically, the comment at the bottom about adjusting max buffers.

Try adjusting that and see if that clears it up.

JimD.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Closing Comment

by:patrickgermain
ID: 34978378
GREAT
we have found solution with the thread above    

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Remote_Desktop-Terminal_Services/Q_25091616.html 


Solution : With Server 2008 64 bits multicore and MsAccess 2003 , we have put maxbuffersize on Msjet 4.0 to the max and it's fine.
Many thanks to contributors
Patrick France
0
 

Author Comment

by:patrickgermain
ID: 34978381
GREAT
we have found solution with the thread above    

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Remote_Desktop-Terminal_Services/Q_25091616.html 


Solution : With Server 2008 64 bits multicore and MsAccess 2003 , we have put maxbuffersize on Msjet 4.0 to the max and it's fine.
Many thanks to contributors
Patrick France
0
 
LVL 58
ID: 34979038

 Excellent.  Thanks for posting that back.

JimD.
0

Featured Post

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

628 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