Can someone enlighten me ?

I was accessing data from MS Access just fine, when it started giving me this error :
-------------------
[37000] [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
L (FOC1406) SQL OPEN CURSOR ERROR.
-------------------

I didn't (intentionally) change my connection to that database, and other connections (also to MS Access databases) are fine, and even rebuilding it didn't restore it.

I'm able to link another database to the table, and access it through the other database (kind of circuitous, but it works !), so it's not the table, MDF, or ACX.

I've lost connections before and rebuilding worked OK, but not "syntax error in FROM clause," and not this time.

Thanks in advance for any insights you may have for me !

Charles,

It may be an MS ACCESS keyword is being used as a table name, for example the word "ORDER"

The following links may be helpful:

List of Reserved words for MS ACCESS 2000:
http://support.microsoft.com/kb/q209187/

List of Reserved words for MS ACCESS 2002 and 2003:
http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;Q286335

Thanks ! I'll check that out...

However, I was able to get the table data from the Access table by linking another Access database to the same table, with no trouble.

Kind of 'going around the world' to get there, but I'm thinking it rules out anything being wrong with the table itself ?

Or, are you thinking it may be something else in the database indirectly causing the problem ?

I can't get to any table, unless I link to it through another database.

Weird !

Thanks for something to investigate ! I'll be back...