Fix Missing Tables in Microsoft Access Query Design View
Question details
The user needs to make tables and relationships visible again in a Microsoft Access query's Design View.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Editing an existing query in Design View after its table objects have moved outside the visible design area.
- Observed behavior
- The query still runs, but scrolling does not reveal the tables or relationships.
Open the affected query and confirm that it still runs. You will need to copy its complete SQL statement and create a new query in the same database.
Rebuild the query layout from its SQL statement
Use this method when table objects are off-screen and scrolling cannot bring them back into view.
Open the affected query, then select View > SQL View.
Select the entire SQL statement in the SQL View editor and copy it.
Select Create > Query Design. Close the Add Tables or Show Table pane if it appears, then select View > SQL View.
Paste the copied statement into the new query's SQL editor, replacing any existing text. Select View > Design View to let Access rebuild the table layout.
Check that the tables and relationships are visible, then run the new query and compare its results with the original. Use Save As to give the rebuilt query a new name, or replace the original only after verification.
Work with exported Access query results in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. It can open compatible Office files for an easy transition, although it does not repair Access queries or replace Microsoft Access.

Frequently Asked Questions
Why does my Access query run when its tables are missing from Design View?
The table objects may be positioned outside the visible design area while the SQL remains intact. Open View > SQL View to inspect the statement.
Will copying the SQL change the query's results?
Copying the complete statement preserves the query logic, but you should run the new query and compare its results with the original before replacing it.
What if Access cannot display the new query in Design View?
Some SQL statements cannot be represented fully in Design View. Continue working in View > SQL View and retain the original query.
Can WPS Office restore missing Access query tables?
No. Rebuild the query in Microsoft Access. WPS Spreadsheets can work with query results after they are exported to a compatible spreadsheet format.




