Unanswered: avoid/hide a specific error message revealing the share name
I have linked some tables directly to a share on another machine, which is supposed to be left on at all times. When it is off, however, I want the error message that appears on the machine trying to access that database to both suggest that the other machine is turned ON, but also to avoid having Access' standard message for that error revealing the name of the share (the full name is included in the standard error message). Which error is this, how can I "trap"/change it?
Error is most likely 3044
Use the Form_Error event if the form is throwing the first error.
You probably want to close the application vs the form as I have done and add a better message - but this should get you started.
Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = 3044 Then GoTo Process_Err
MsgBox "Table Not Connected"
Response = 0