How to Find Access Queries That Reference Linked Tables
Question details
The user needs to identify which queries, reports, or forms in a large Access database rely on specific linked tables for an ODBC connection.

- Product
- Microsoft Access 2016
- Device & OS
- not provided
- Scenario
- Managing a database with over 100 objects and attempting to map out ODBC linked table dependencies to clean up or migrate connections.
- Observed behavior
- The built-in Object Dependencies feature does not reliably provide dependency information or is unavailable for external linked tables.
Before attempting to map your query dependencies, verify that your ODBC connections are active and the external data sources are reachable, as disconnected linked tables can prevent the Database Documenter from analyzing dependent queries properly.
Use the Access Database Documenter
Utilize the built-in Database Documenter to generate a comprehensive textual report of your database queries, which you can then search for linked table names.
Since the Object Dependencies pane fails for linked tables, the Database Documenter is the most reliable native tool to extract object metadata. It generates a detailed report containing the SQL definitions of all selected queries, making it easier to spot references to specific external tables in bulk.
Navigate to the 'Database Tools' tab on the Access ribbon and click on 'Database Documenter' located in the Analyze group.
In the Documenter dialog box, click the 'Queries' tab. Click 'Select All' if you want to inspect the entire database, or individually check the queries you suspect contain the linked tables.
Click 'Options' to configure what information prints. For finding table names, ensure 'SQL' is checked under the query properties, then click 'OK'.
Access will generate a printable report. Export this report to a PDF or Word document, then use the 'Find' shortcut (Ctrl + F) to search for your linked table's name within the SQL definitions.

Search Saved Query SQL Manually
Inspect the SQL code of individual queries directly within Access to identify JOINs or FROM clauses calling the linked tables.
Employ a Trusted Access Analyzer Utility
Use specialized third-party analyzer tools designed to map out full database dependencies, bypassing native Access limitations.
Looking for a Lightweight Office Suite? Try WPS Office
While WPS Office does not feature a direct relational database application like Microsoft Access, it is an exceptionally lightweight and powerful suite for handling all your exported database data. If you regularly export Access query results to Excel or CSV formats for analysis, WPS Spreadsheet provides an intuitive, high-performance environment to visualize, filter, and chart your data seamlessly.
- 1. Export Access Data: Export your desired query results or table data from Access into an Excel (.xlsx) or CSV file.
- 2. Open with WPS Spreadsheet: Launch WPS Office and open your newly exported file directly in WPS Spreadsheet.
- 3. Analyze and Visualize: Utilize built-in pivot tables, advanced filtering, and charting tools in WPS to seamlessly analyze your database records.

Frequently Asked Questions
Why is the Object Dependencies feature disabled for linked tables in Access?
Access natively tracks dependency metadata internally for local tables. However, because linked tables connect to external OLEDB or ODBC data sources, the Access engine cannot completely parse external schemas, resulting in the Object Dependencies feature being disabled or unreliable for those objects.
Can Access Database Documenter find dependencies in forms and reports too?
Yes, the Database Documenter can analyze forms, reports, macros, and modules. You can select these objects in their respective tabs within the Documenter dialog box to print out their properties and underlying record sources.
Will these methods work for identifying references in Power Pivot or Power BI?
No. Access tools are strictly designed for Microsoft Access databases (.accdb or .mdb). To analyze dependencies inside a Power Pivot data model or a Power BI file, you need specialized Power BI metadata extractors or DAX analyzer tools.
Is there a way to search query dependencies using VBA code?
Yes. You can write a VBA script that loops through the 'QueryDefs' collection in your database, inspects the '.SQL' property of each query, and checks if it contains the string of your linked table name, outputting matches to a message box or a temporary table.




