missing table in join query (1 Viewer)

BoleMK

New member
Local time
Today, 20:00
Joined
Mar 30, 2014
Messages
5
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:
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 14:00
Joined
Feb 19, 2002
Messages
28,764
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.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom