VBA - Ways to tray the error prompt

Hi, when coding in VBA. If the linked table is changed, you would get error message saying the table is missing. In order to bypass the error prompt . You may insert the command as below :



On Error Resume Next
    CurrentDb.Execute "DELETE tbl_dbbc.* FROM tbl_dbbc;"