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
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.
Thanks Travis,
that worked, but found out any changes to a connection’s translator requires a Gateway Service restart.
