I have upgraded our Windows 2000 Terminal Server to Windows Server 2008 with Terminal Server role added. In the 2000 environment, users logged into the server and on their 2000 desktop was an Access shortcut to a frontend file that was linked to the backend database.
The 2008 server is configured the same as the 2000 server as far as user accounts, profiles, home folders, etc. In the 2008 environment, I created a separate RemoteApp for each user, each had an argument pointing to the frontend file located in their home folder (on the 2008 server). I then saved their RemotApp as an RDP and copied it to their local desktop. This seems to be working fine except that certain functions are running extremely slow on the database. These function seem to be most prevetant when applying filters. Specifically (but not limited to), when a user clicks a drop-down box. Access will indicate "Not Responding" and could take minutes until the dropdown list is displayed. Since I still have access to the 2000 server, I compared the functionality on that and these functions are not a problem...all runs at an acceptable speed on the 2000 server.
The same latency problems occurs on the 2008 server when I log in as a user, via RDP, and run the database frontend file from the user's server desktop, bypassing the RemoteApp RDP on the local desktop.(the same way we ran the database on the 2000 server).
I am wondering if I installed Access incorrectly or configured the remote access incorrectly. The 2008 server is 64 bit and the Access program was installed in the Program Files (x86) folder.
I read (after the fact) that an option for installing applications on 2008 terminal server is to run the command line: "change user /install" prior to installing the application. I have also read that this command is executed automatically without the need to run the command line command. Could this be part of my problem?
It seems to me that the problem is not a database design issue as much as a 2008 connectivity issue.
Any help with this would be greatly appreciated.