Missing Tables in Design View

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I went to edit a query in Design View but the Tables are missing. My fields
are all still there and show the correct table names. I selected "Show
Tables" and tried to add them back in, but it populated the table as
"TableName_1" as if the tabel was loaded already.

Any suggestions?
 
Try scroll around the upper pane to find your tables that you think are
missing.
 
I tried that - no luck. I even loaded another table to use as a reference to
ensure a thorough search.
 
Check the SQL view of the query for the table name. If the table name is not
in the SQL view, the query doesn't include the table.
 
To follow-on Duane's responses, consider that Access sometimes gets
"confused" in ways that don't appear in the object (query). You could try
changing to the SQL view, copying the SQL (after inspecting to make sure
it's OK), then creating a totally new query, going to SQL view, and pasting
in your SQL.

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top