Solved

Azure backend of database timing out?

Posted on 2014-11-06
6
226 Views
Last Modified: 2014-11-13
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
0
Comment
Question by:alevin16
6 Comments
 
LVL 14

Assisted Solution

by:Bill Ross
Bill Ross earned 250 total points
ID: 40428124
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
0
 
LVL 26

Accepted Solution

by:
Nick67 earned 250 total points
ID: 40428674
@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
0
 

Author Comment

by:alevin16
ID: 40434179
Thank you very much!
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40434512
But what was the solution?

/gustav
0
 

Author Comment

by:alevin16
ID: 40441630
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.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40442009
Thanks!

/gustav
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query stumper 3 36
Azure SQL Insert not working suddenly 11 21
Sql query 107 25
SQL - insert empty rows into output results 11 22
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now