[ODBC Microsoft Access Driver] Syntax error in FROM clause.
Posted on 2004-10-13
in response to the following query in access97:
SELECT zhaghevra.* FROM c:\my documents\projects\binaw\DATA\Binaw.mdb.zhaghevra WHERE zhaghevra.MisHevra = 1
i'm getting error number -2147217900
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
caused by Microsoft OLE DB Provider for ODBC Drivers
whe trying to open the recordset.
this used to work before upgrading to win2k and to vb6 sp6
can any one point me to what has changed due to the upgrdes that influences
the behavior of the driver?