# Database Query Browser with MS Access issue

**URL:** <https://forum.inductiveautomation.com/t/database-query-browser-with-ms-access-issue/6200>\
**Category:** Ignition\
**Created:** [April 10, 2013, 3:06pm UTC](https://forum.inductiveautomation.com/t/database-query-browser-with-ms-access-issue/6200 "2013-04-10T15:06:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [April 10, 2013, 3:06pm UTC](https://forum.inductiveautomation.com/t/database-query-browser-with-ms-access-issue/6200/1 "2013-04-10T15:06:21Z")

</div>

have customer who has existing MS Access tables with production schedule data.  
Setting up test database connections to get familiar with querying data from Access.  
Have an ODBC:dsn already condigured and working.  
Cannot get simple queries to work in the Database Query window,  
but an Sql Query on a table will work with the same syntax inputted in the Query Window.

V7.5.6

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/2e8af77af7b75821c8d28040108e0076919eda7b.jpg)  

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/818bddb8ca2f12ba19a5527bf296af3f1cbec3cc.jpg)

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [April 10, 2013, 3:53pm UTC](https://forum.inductiveautomation.com/t/database-query-browser-with-ms-access-issue/6200/2 "2013-04-10T15:53:35Z")

</div>

Yes I can see that happening. We append a limit to the queries in the Query Browser. The limit syntax is based on the translator for that database so it probably isn’t configured correctly. You should edit your database connection and set the translator to MSSQL.

---

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [April 10, 2013, 6:38pm UTC](https://forum.inductiveautomation.com/t/database-query-browser-with-ms-access-issue/6200/3 "2013-04-10T18:38:14Z")

</div>

Thanks Travis,  
that worked, but found out any changes to a connection’s translator requires a Gateway Service restart.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/cd39a10354a3f7bbe6a32945493c3b5eb5392b6a.jpg)