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
Solved

Access 2003 Running Slow on Windows 2008 Terminal Server

Posted on 2011-02-23
6
985 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 57
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 57

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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

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 57
ID: 34979038

 Excellent.  Thanks for posting that back.

JimD.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

839 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