I have an older ms access based application (third part) that use a remote MS sql database as datasource. The clients runs the application locally and connects to the remote database through internet/VPN. My problem is that the connection to the SQL-database are lost all the time - and the application crashes.
Unfortunally the application has no way to handle lost sql connection, and the clients need to shut down the application and restart it to keep the application running.
I have no way to modify the third parts application code.
Do anyone have workaround for this SQL reconnection problem ?