I have 10 tables from my Access DB that I have linked into an Excel Report that I have created using ODBC access to my DB. The issue is that if I forget to close the Database before I hit Refresh or Refresh All in Excel I get these two error messages attached. And the only way to I seem to be able to fix the issue is to relink each table all over again and since I have already formatted the tables in Excel this is quite time consuming.
Is there any way to prevent the error from happening if I have Access open when I go to hit refresh or a faster way to fix it if I forget to close Access with out having to link the tables all over again....