Link to home
Start Free TrialLog in
Avatar of Voodoo_chile
Voodoo_chile

asked on

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?
Avatar of thecomputerdocs
thecomputerdocs
Flag of United States of America image

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.
Avatar of Voodoo_chile
Voodoo_chile

ASKER

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.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Nick67
Nick67
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
These solutions suggest that Access (especially bounded form) is not the proper techonology using in the poor or slow network connections.