MS Access and ODBC

[Guest.Visitor]

Hello, I am running this Pass-Through Query in Ms Access SELECT * FROM QS36F/"PI1.MODL" And it works fine except that Access gives me this Error message befor e showing the data. Syntax error in FROM clause.

[T.Holt]

The SQL standard is to separate the library and the file name with a period, not a slash. That may be your problem. color="blue"> On Saturday, May 02, 1998, 07:28 AM, Francois Lacoursiere wrote: Hello, I am running this Pass-Through Query in Ms Access SELECT * FROM QS36F/"PI1.MODL" And it works fine except that Access gives me this Error message befor e showing the data. Syntax error in FROM clause.