alevin16
asked on
Azure backend of database timing out?
Hello All
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?
Thanks
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?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
But what was the solution?
/gustav
/gustav
ASKER
Hi Gustav
I was able to use the trick above where I have a dummy form and I refresh it every 15 minutes. It worked nicely.
I was able to use the trick above where I have a dummy form and I refresh it every 15 minutes. It worked nicely.
Thanks!
/gustav
/gustav
ASKER