# Executing an ODBC driver's stored procedures in Microsoft Access

**URL:** <https://community.cdata.com/t/executing-an-odbc-drivers-stored-procedures-in-microsoft-access/231>\
**Category:** CData Drivers\
**Tags:** discussion, odbc, microsoft-access, ms-access, stored-procedure\
**Created:** [June 30, 2023, 3:53pm UTC](https://community.cdata.com/t/executing-an-odbc-drivers-stored-procedures-in-microsoft-access/231 "2023-06-30T15:53:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elizabeth\_G](https://avatars.discourse-cdn.com/v4/letter/e/6bbea6/32.png) [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\
**Post date:** [June 30, 2023, 3:53pm UTC](https://community.cdata.com/t/executing-an-odbc-drivers-stored-procedures-in-microsoft-access/231/1 "2023-06-30T15:53:55Z")

</div>

If you are using an ODBC driver and wish to execute one of its stored procedures in Access, you will need to go to Create → Query Design, and select Pass-Through. You can then write the query for the stored procedure, such as&nbsp;“EXECUTE CreateJob Action = ‘Insert’”. Upon selecting Run, you will be prompted to select your ODBC connection so the stored procedure can be used with it.

 ![5cdde6f5-5398-432a-92e6-55323d2a0da6.png](https://us1.discourse-cdn.com/cdata/original/2X/0/0b1843a0f51f345029d71685ce94cc35d95ca871.png)