Toad World® Forums

Script error running query against MS Access


#1

Able to view data in table using Viewer but when send to Query Builder, get Script Execution Error: ERROR 42000 ODBC Syntax error in FROM clause. Is there a fix for this?

Thanks

ODBC error.jpeg


#2

Hello Michael, I see the problem in 1.1.1 with tables that have spaces in the name because our application does not surround the table name with the necessary quote characters used by Access (the ` character). Is this the problem you are running into also? I corrected the SQL statement by sending it to the editor and adding the necessary characters around the table name.

As you may well have noticed (since you are one of our dedicated beta testers), this issue does not occur in our beta 2.0 release.

If this is not the issue you are running into, please let us know.