Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2003 Running Slow on Windows 2008 Terminal Server

Posted on 2011-02-23
6
Medium Priority
?
1,011 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
  • 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 2000 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

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

Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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…

971 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