It can take time for the dao to complete making an MS Access table link to a table. One known symptom of this is an error message stating that MS Access "cannot find the input table". The only solution we are aware of is to sleep the thread to give more time for the link to complete. Recently we have also started seeing the error message below when trying to link to SQLite tables. It may be a different manifestation of the same problem. Use this issue to track adding sleep statements after creating SQLite table links to see if it helps.
It can take time for the dao to complete making an MS Access table link to a table. One known symptom of this is an error message stating that MS Access "cannot find the input table". The only solution we are aware of is to sleep the thread to give more time for the link to complete. Recently we have also started seeing the error message below when trying to link to SQLite tables. It may be a different manifestation of the same problem. Use this issue to track adding sleep statements after creating SQLite table links to see if it helps.