I have Access databases that use a SQL Server backend. Is there a simple way to have Access detect if a connection to the SQL Server has been lost?

I tried having a column comparison from time stamps. That didn't work.

Desired result is when a SQL Server connection is lost to have Access display a message and automatically close.

CodePudding user response：

Maybe it would help you to use a newer version of Microsoft Access (you didn't write which one you use) to let Microsoft Access reopen a lost connection without the need to restart it.