I have a form, in datasheet view.
The form data source is a disconnected recordset.
This is connected at runtime.
It was setup this way to speed up things which has worked amazingly.
One problem I have,... if the network connection is interrupted and the user tries to update a record, I get the error "Data provider or another service returned an E_FAIL status".
This is a dialog box with one "OK" button.
I'm trying to intercept this error message via the Form_Error procedure, but this is not being triggered.
How can I detect this situation?
If I can, I can resolve this by reconnecting the data connection without any disruption to the user.
Thanks 🙏🙏🙏