Azure backend of database timing out?

alevin16
alevin16 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Bill RossProgrammer
Commented:
Hi,

In your front end create a bound form. Set the recordsource to a little used table.  Open it invisible when the user opens the front end.  That will maintain a persistent link to the DB and prevent time out.

Regards,

Bill
Most Valuable Expert 2014
Commented:
@Bill Ross's suggestion may or may not work with Azure, but it is certainly worth trying.
What he is describing is an old performance enhancing trick that should be used on any FE/BE application that uses DAO.
Such applications perform better when a connection they make to the backend persists for the entire lifetime of the application.  In my application, I have 'tblDummy' that has a text field (field1) and a timestamp field(SSMA_Timestamp).  In the application, I have 'frmDummy' that is based off that table with a textbox (field1).  The OnLoad event of the start up form of the application calls
DoCmd.OpenForm "frmDummy", acNormal, , , , acHidden
That form sits quietly in the background, hidden, persisting the connection to the database.

That may or may not be enough for Azure.

But we could extend the idea.
My dummy form does nothing.  Yours could do something on a timer interval
Sub Form_Load()
Me.TimerInterval = 1200000 '20 minutes
End Sub

Sub Form_Timer()
Me.Field1.Requery
End Sub

Open in new window


So, once every 20 minutes, the form will requery its control.
That may be enough to keep Azure from timing out.

Nick67

Author

Commented:
Thank you very much!
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
But what was the solution?

/gustav

Author

Commented:
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.
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
Thanks!

/gustav

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial