One day, one of our Vice-Presidents gets fed up with Microsoft Access 97 performance over a VPN. Yea, I know. Running Access over VPN connections is slooooooow. But, the timesheet application is written in Access 97 and it connects to all our custom accounting applications which are also written in Access 97. And the VP needs to be able to complete his timesheet in a reasonable amount of time. Speed up the story... can't rewrite the application or migrate to Web front end with SQL backend. So what is a IT Manager to do?
How about dedicating an old workstation to running the Access 97 timesheet application?
Yea, there are ways to allow multiple terminal server sessions on an XP box but I don't really want to break Microsoft licensing. Oh yea, and I'd like a seemless application rather than a remote desktop that users will have to figure out.
Here's what works for now:
1. On the old workstation running Windows XP, turn on remote desktop. Plenty of instructions on web on how to do that.
2. Install
KB961742-v3. I know it says that it is for Windows 7 XP mode, but hey, it works on a physical box too.
3. Use this
Remote App tool on the XP box to configure the Remote App. Thanks Kim Knight!
4. Use that app to also create the rdp file.
Okay it works... but the only problem? Remote App sessions are set to never terminate by default. They simply disconnect. But on XP this is a problem because then no local users can use the machine or the next person to use the RemoteApp has to boot the previous user.
It took a while to find, but Windows Server 2008 has a Group Policy to set a timeout to terminate disconnected sessions. Well, if you take apart the .admx file, you can pull out the registry setting that needs to be changed.
As a shot, I applied that registry setting to the XP box and Voila!
The registry setting is:
HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT\Terminal Services
"MaxDisconnectionTime"=dword:0000ea60
The value is the timeout in seconds * 1000. Google it and you'll find out more than you need to know.
So now, after 20-40 seconds the XP machine terminates the disconnected session and the machine is back to normal as far as being able to be used by a user on the console or the next Timesheet session.
Now my VPN users can use the seemless timesheet application and the only network traffic over the VPN is the KVM traffic. So it is nice and speedy. I only have a handful of people on the VPN at a time, so they'll have to deconflict usage of the timesheet.
Cheers and Good Luck,
Clyde