I'm working with an o365 Front end, linked to mysql backend on aws rds. I'm at point of testing for no connection, or if the connection drops while access is open.
For now, when i force loss of connection - first it opens up the odbc mysql login form - then some error messages - then odbc 3151...it's messy. I've tried to trap this 3151, but does not ever get to the error handler.
I wonder if would be helpful to check the network status at startup, and then at intervals perhaps. I would think I would just have to test that the internet connection is up.
Ideally, I'd like to handle and trap this loss of connection, in clean way for the users (message saying 'no connection - try again later,' - and then shutting down Access without all the other errors..
any feedback, suggestions welcome!
thanks!