How do I stop an ADO from giving errors in message boxes? I've got a program that I want to be kept running continuously, but if an ADO encounters a problem it shows the error in a message box and stops everything else from running until OK is clicked.
I've tried using the Adodc1_Error event, which allows me to do what I want with the error message, but after that piece of code executes the message box from the ADO appears. I've also tried saying on error resume next in the Adodc1_Error sub, as well as on error goto to a label, which just exits the Adodc1_Error sub, but no matter what I do I still get a message box from the ADO.
Any help would be much appreciated.
I've tried using the Adodc1_Error event, which allows me to do what I want with the error message, but after that piece of code executes the message box from the ADO appears. I've also tried saying on error resume next in the Adodc1_Error sub, as well as on error goto to a label, which just exits the Adodc1_Error sub, but no matter what I do I still get a message box from the ADO.
Any help would be much appreciated.
