Access with SQL backend on an Azure machine randomly drops connection
Posted on 2015-02-22
Well I got my employment squared away so I am back in the saddle! I have an issue with a previous program I worked on.
I have an Access front end that connects to the data on the backend on an Azure server running SQL (I hope I am saying all this correctly. I know very little about SQL and Azure).
For the most part the connection works great for everyone. Every so often though a person will be using the program and they lose connection to the Azure server. They have to exit the Access program (I have an Exit button) and then restart it.
There does not seem to be a pattern. It could be happening for one person but yet another person, at that same time, is having no issue at all.
I would love to see if anyone has an idea as to what could be going on, but I would also like to put into the Access program some sort of monitor that watches the connection (maybe in the Timer of the Main Form) every minute (or whatever is a good time frame). I would love to have a red and green light on the Main Form that shows the connection status plus I would like it to add data to a table when the connection goes down. This way I could start seeing if there is any pattern.
Thank You all and for anyone who answered my previous questions, I am really sorry I dropped out of existence, I lost my main job and was scurrying to make sure my family was ok.