Custom message for error message "MySQL server has gone away"??

[perlfan]

Hi - is there a way to display a custom message when Access loses the ODBC connection to the MySQL database? The default message is somthing like "MySQL server has gone away" Lost connection etc.

I would like to customize the message. Is this possible?

Thanks a lot for advice! FRANK

 

[gemma-the-husky]

on each form, you can create an event handler and put it in the "on error" event - and use that to change the standard message.

the problem is, though, that if you lose the connection to the back end, whatever you do is moot. you cannot continue to process data. the best you can do is probably shut down the app.

depending on exactly what you are doing at the time, you could end up with partially updated records, which is the biggest problem. (both identifying any issues, and fixing them)