Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Losing connection to access database located on cloud server

Posted on 2014-10-06
9
Medium Priority
?
262 Views
Last Modified: 2014-10-14
I am getting the attached error message when accessing an access 2010 database that is located on a cloud server.  It happens intermittently.  Other applications, can be accessed with no problems.  The problem seem limited to Access.  This is the only Access database that is located on the cloud server and multiple users access it.  I'd like to get some ideas of what could be causing this problem.  The network guys are stumped and I am looking for fresh ideas on what could be causing this problem.  The error message does not appear to be an Access error message.
disconnect.jpg
0
Comment
Question by:chtullu135
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 40364751
You haven't described how you connect. It is typical of a remote desktop disconnect.

I use these regularly, and usually only see this if a VPN is in place and that disconnects. It can be momentarily - other internets sessions will reconnect, but a VPN one will need the VPN to re-establish itself.

Alternately, the cloud provider may have a firewall or similar plan in place that drops connections after a set amount of time. This can be quite common for RDP sessions (typically between 30 and 120 minutes).


Kelvin
0
 
LVL 58
ID: 40364765
<<I am getting the attached error message when accessing an access 2010 database that is located on a cloud server.  It happens intermittently.>>

 Your problem is not Access; it's RD (Remote Desktop).    

 You've got a logon to a remote server through RDP and that's what's getting disconnected.  You may be using Access, but this has nothing to do with Access.

Jim.
0
 

Author Comment

by:chtullu135
ID: 40364868
Thanks Jim,  I haven't noticed that problem occurred with other applications.  However, since the problem is intermittent, it could very well be happening with other applications..  Kelvin's point about a firewall dropping connections after a set time may also be contributing factor.  It may be that the users are using accessing the access database and not closing the connection when they are done.  I'll ask the users.
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
LVL 39

Expert Comment

by:PatHartman
ID: 40364917
Access is the canary in the coal mine so to speak when it comes to flaky connections.  Access has a very close connection with it's BE and can't recover gracefully from intermittent drops.

You might have to convert the BE to SQL Server.  Since Access expects to connect and disconnect to a SQL Server BE, it is more stable in this situation.
0
 
LVL 51

Expert Comment

by:Gustav Brock
ID: 40365566
Jim is right. This has nothing to do with Access as it runs at the remote site.

It is solely a loss of connection between the user's Remote Desktop client and the remote server. The client is quite sensitive to drops of connection, and you'll see the message; however, it is also quite good to regain normal operation once the connection is reestablished.

/gustav
0
 

Assisted Solution

by:chtullu135
chtullu135 earned 0 total points
ID: 40370999
Hello Pat,  
Why would using a SQL server backend make the connections more stable.  I mean it sounds right.  I imagine since SQL server is designed from the get-go to be used as a backend, it is inherently more stable than an Access backend
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 40371018
@chtullu,

  The connection Access has with a DB file is not the issue here, it's your connection to a remote desktop server that is getting cut off.  As Kelvin said, that may be by design.    RDP sessions can be set to disconnect or log off after a certain amount of time or a certain amount of time of inactivity.  Then on top of that is all the usual stuff, like an actual flaky connection over a VPN.

  But yes, SQL Server is by far more robust because it has a server side process that acts as a door man for the DB.   No one gets to the DB otherwise and all connections run through the door man.

  in contrast, with a JET or ACE DB (the default DB for Access), every client reaches out to the DB file and manipulates it directly.   There is no server side process.  The server acts as nothing more than a file sharing device.

Jim.
0
 

Author Comment

by:chtullu135
ID: 40371040
That makes a lot of sense Jim.  Thanks.
0
 

Author Closing Comment

by:chtullu135
ID: 40379400
Thanks for the help.  I am advising the client to migrate the backend to sql server
0

Featured Post

DFW AZURE MEETUP TONIGHT FRI 6PM

We will be discussing what Azure Stack is, how does it fit into the suit of offerings that Azure has currently, and where can it fit into your organizations technology stack. We will also be discussing limitations of the platform while covering various applicable scenarios.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
You deserve ‘straight talk’ from your cloud provider about your risk, your costs, security, uptime and the processes that are in place to protect your mission-critical applications.
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 …
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…

704 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