[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

Access Loss of Connection to SQL Server Database

Our loss of connection to the SQL Server database is handled very inelegantly, the user receives an error message which keeps on reappearing until the user forces the application to shut down.  How is it possible to handle the loss of connection to the database elegantly?
2 Solutions
The error message indicated that the raw data that you entering into the SQL database has been disrupted, which can lead to data loss. It's a serious problem and rather than have it not error, or show the error, I woud begin looking into why it's disconnecting in the first place.
If this happens frequently, I'd look into network latency, bad cables, network cards, bad switches, etc.
Voodoo_chileAuthor Commented:
The problem is the VPN disconnected after a certain time so the Access database connection is lost. My question is how to make Access re-connected after the VPN is manually re-connected rather than the user receives an error message which keeps on reappearing until the user forces the application to shut down.

You can't reconnect Access
If you drop the connection, the Access app is hosed until it is shut down and re-opened.
The errors possible are myriad, and I don't think that you can cover all the possibilities and close gracefully

If you are to use Access in a VPN situation, the connection must be almost bulletproof.
If it cannot be bulletproof, you are using the wrong technology, and must look to ASP/Web technologies.

RDP and RemoteApp are possibility, but Access MUST maintain a good connection to the SQL Server at all times
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The only real way to manage this more elegantly is to switch to unbound forms and manage the connection to your database entirely through code. This is a massive undertaking, of course.
Voodoo_chileAuthor Commented:
These solutions suggest that Access (especially bounded form) is not the proper techonology using in the poor or slow network connections.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now