Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Network Issues _ Disconnecting Rdp Session Stops Access App

Posted by: Interlektual Oct 23 2019, 12:22 PM

I have an Access application that pulls data out of an accounting system (Quickbooks), processes and transforms it then inserts it into a SQL Server database.
This app runs 24/7 on a Windows 10 virtual machine (VMWare) which is controlled by a remote desktop connection. The app is started by connecting in using RDP, logging on, starting the app then disconnecting the RDP session to leave it running 'headless'.

This has been working for over a year but has, in the last week or two, developed an issue. When you disconnect the RDP session the app freezes, and seamlessly resumes when you reconnect. I know this is happening as the app generates an event log which has gaps in it corresponding to the time the VM/RDP is disconnected.

Has there been a Windows update which has changed the behaviour of disconnected RDP sessions? There have not been any changes to the VM or the app other than usual Windows Updates.

Bit stumped, any help, ideas appreciated !

Posted by: DanielPineault Nov 21 2019, 06:00 AM

I don't have an answer for you, but can confirm I have seen several other people report the exact same issue in various forums. It would be a good guess that this is somehow related to an update. You would need to review you computer logs to see what has recently been installed and then try uninstalling them one by one until you locate the culprit.

Posted by: payfast8898 Nov 21 2019, 05:13 PM

you might try a app called alwaysup we have used it in the past to keep a ms access application open and running in the back ground even if you are logged off. Win 10 have been changing alot of the coding for the rdp because they want to start selling license to use it like server software can so many people using patches to do multiple log ins and they are not making any money off of it. anyways that is what we have used in the past seems to work very well

Posted by: AlbertKallal Nov 21 2019, 07:02 PM

Is this a VM on Terminal Services, or are you just remoteing into the VM?

If its terminal server, then there i a good number of settings:

You can set this on the host server (if using terminal services).

Open gpedit.msc

Browse to Computer Configuration --> Administrative Templates --> Windows Components --> Remote Desktop Services --> Remote Desktop Session Host --> Session Time Limits.

Enable the "Set time limit for disconnected sessions" and set it to Never

I don't know if the above will fix, or work if you are NOT using terminal services, but it worth a look at.

Regards,
Albert D. Kallal (Access MVP 2003-2017)
Edmonton, Alberta Canada

Posted by: PhilS Nov 22 2019, 05:03 AM

QUOTE
When you disconnect the RDP session the app freezes, and seamlessly resumes when you reconnect.

This seems to be related to the May-2019 Windows 10 updates.

A workaround is to use the XDDM instead of WDDM display driver model. - Using these keywords on Google should get more detailed instructions.