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?
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
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
These solutions suggest that Access (especially bounded form) is not the proper techonology using in the poor or slow network connections.
If this happens frequently, I'd look into network latency, bad cables, network cards, bad switches, etc.