missing table in join query (1 Viewer)

Hi all,
I have join query of 3 tables. The third one is linked table from other location that is sometimes unavailable, so the linked table is missing from time to time. When this happens the query returns 'missing table' error.
Any idea how to avoid this, and get null result replacing the missing fields, so the other part of query returns data.
thanks,
Bole:banghead:

Welcome aboard,

The structure of a query cannot be changed on the fly so the short answer is NO.

You could use VBA to determine the existence of the third table and run two different queries but whatever you are doing with the queries would also have to change since sometimes fields are present and sometimes they are not.

The real solution is to ensure that the table is always present. It may be empty as long as you are using left-joins but it MUST exist.