# Optimize Microsoft Access with SQL Pass-Through Queries

**URL:** <https://community.cdata.com/t/optimize-microsoft-access-with-sql-pass-through-queries/1038>\
**Category:** CData Drivers\
**Tags:** sql, discussion, salesforce, odbc, microsoft-access, ms-access\
**Created:** [March 10, 2025, 8:02am UTC](https://community.cdata.com/t/optimize-microsoft-access-with-sql-pass-through-queries/1038 "2025-03-10T08:02:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohsin](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@Mohsin](https://community.cdata.com/u/Mohsin)\
**Post date:** [March 10, 2025, 8:02am UTC](https://community.cdata.com/t/optimize-microsoft-access-with-sql-pass-through-queries/1038/1 "2025-03-10T08:02:53Z")

</div>

Looking to enhance performance in **Microsoft Access**? Learn how SQL pass-through queries can help you execute SQL directly on external databases, reducing bottlenecks and improving efficiency.

Go beyond the native capabilities of Microsoft Access pass-through queries with **CData ODBC Connectors,** leveraging **sys\_tables** and **sys\_tablecolumns** system tables to retrieve metadata more efficiently and comprehensively.

Read the full guide here:&nbsp;[**SQL Pass-Through Queries in MS Access**](https://www.cdata.com/kb/articles/passthrough-queries-ms-access.rst)