I have a database where the front end is on everyone's computers and the backend is up on Azure. When someone leaves the front end on (for example if they go to lunch) when they come back it is as if the backend disconnected. They have to restart the frontend in order to reconnect.
Is there something in Azure where I can tell it to not disconnect if there is no activity? Or is there something I can add to the frontend in Access that continually pings the backend so that it thinks someone is there?
Microsoft AccessCloud ComputingMicrosoft SQL Server