Access tables and queries
xlide_access_catalogReveals the data structure of an Access database by listing its tables, saved queries, and relationships, helping you understand the app beyond its VBA code.
Instructions
Lists what an Access database holds besides its code: tables with their columns, saved queries with their SQL, and the relationships between tables. An .accdb is an application rather than a document, and the VBA in it is written against these, so reading the modules alone shows half of it. Access files only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| include | No | 'tables', 'queries', 'relationships' or 'all'. | all |
| file_path | Yes | Absolute path to the Access database. | |
| include_system | No | Include the MSys tables and relationships Access keeps its own objects in. Off by default: every database has them, and listing them buries the few that are about the user's data. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||