Others

How to Check if Deleting Linked Tables Breaks Queries in Access

Maira Mehtab Sep 28, 2026 869 views

Question details

The user needs to determine whether removing linked Excel tables from an Access database will negatively impact dependent objects such as queries, forms, and reports.

Product: Microsoft Access
Device & OS: not provided
Scenario: Cleaning up or restructuring a database by removing linked external spreadsheet tables without causing errors.
Observed behavior: Requires a method to safely identify dependent objects before proceeding with the deletion of linked tables.

Before you start

Before making structural changes, ensure you create a complete backup of your ACCDB file. It is highly recommended to test the deletion of linked tables in a secure copy of your database first.

Solution 1Recommended

Use Object Dependencies to Review Related Objects

Access provides a built-in Object Dependencies pane that allows you to instantly see all database objects relying on the linked table you plan to delete.

This is the safest and most direct method to map out how a linked Excel table is being utilized across your database.

Select the Linked Table

Open your Access database and select the linked Excel table from the Navigation Pane on the left side of the screen.

Open Object Dependencies

Navigate to the 'Database Tools' tab on the ribbon and click on 'Object Dependencies' located within the Relationships group.

Review the Dependencies List

A pane will appear on the right side. Select 'Objects that depend on me' to view all queries, forms, and reports that will break if the table is deleted.

Name AutoCorrect Requirement: For this feature to work, 'Track name AutoCorrect info' must be enabled in your Current Database options.

Solution 2

Generate a Database Documenter Report

Use the Database Documenter to create a comprehensive, printable report of your database design to manually review complex dependencies.

Free Microsoft Office alternative

Manage Your Source Spreadsheet Data Seamlessly with WPS Office

While Microsoft Access manages relational databases, you still need a reliable tool to clean, format, and organize the Excel data you link to your database. WPS Office is a highly compatible, free, and lightweight suite that perfectly manages XLSX and CSV files, serving as a powerful alternative for all your spreadsheet and document needs.

1. Download the Suite: Visit the official WPS website to download and install the free, lightweight office suite.
2. Open Your Tabular Data: Launch WPS Spreadsheets and open the Excel file you intend to link to your database.
3. Organize and Save: Format your columns cleanly, remove empty rows, and save it in a highly compatible XLSX or CSV format.

Perfectly compatible with Microsoft Excel (.xlsx, .xls) and CSV formats, ideal for preparing tabular data before linking.Lightweight installation with a familiar, tabbed interface for seamless migration.Free access to comprehensive tools for Spreadsheets, Writer, Presentation, and PDF.

Frequently Asked Questions

What happens if I delete a linked table in Access that has active dependencies?

If you delete a linked table that other objects rely on, any queries, forms, macros, or reports referencing that table will fail to run. You will receive 'Table or view does not exist' or similar parameter errors when attempting to open them.

Why is the Object Dependencies button grayed out or disabled?

The Object Dependencies feature may be disabled if the 'Track name AutoCorrect info' option is turned off. You can enable this by going to File > Options > Current Database, checking the box for 'Track name AutoCorrect info', and restarting your database.

Will deleting a linked table in Access delete the original Excel file?

No. Deleting a linked table inside Microsoft Access only removes the connection from the database to the file. The original source Excel workbook remains completely safe and untouched on your computer or network drive.

Office Quick Solutions