Office Settings & Configuration

Fix Missing Tables in Microsoft Access Query Design View

Ayan MasoodAyan Masood Nov 14, 2026 869 views

Question details

The user needs to make tables and relationships visible again in a Microsoft Access query's Design View.

Fix Missing Tables in Microsoft Access Query 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.
Before you start

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.

Solution 1Recommended

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.

1
Open SQL View

Open the affected query, then select View > SQL View.

2
Copy the SQL

Select the entire SQL statement in the SQL View editor and copy it.

3
Create a blank query

Select Create > Query Design. Close the Add Tables or Show Table pane if it appears, then select View > SQL View.

4
Paste and rebuild

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.

5
Verify and save

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.

Design View limitations: Some SQL statements cannot be displayed fully in Design View. If Access cannot switch views, keep the original query and review the SQL in SQL View.
Free Microsoft Office alternative

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.

Review and organize Access query results exported to a spreadsheetOpen and edit common Microsoft Office formats, including XLSX, DOCX, and PPTXUse familiar spreadsheet and document tools in a lightweight office suiteMove existing compatible Office files into your WPS workflow
microsoft office alternative - wps office

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.