Solved

Azure backend of database timing out?

Posted on 2014-11-06
6
222 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
Comment Utility
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
Comment Utility
@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
Comment Utility
Thank you very much!
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
But what was the solution?

/gustav
0
 

Author Comment

by:alevin16
Comment Utility
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
Comment Utility
Thanks!

/gustav
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Big data transfers via information superhighways require special attention and protection. Learn more about the IT-regulations of the country where your server is located. Analyze cloud providers and their encryption systems for safe data transit. S…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

743 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

16 Experts available now in Live!

Get 1:1 Help Now