Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ODBC MS Access causes Syntax error in FROM clause

Read-Only Read-Only Topic
Go
Search
Notify
Tools
ODBC MS Access causes Syntax error in FROM clause
 Login/Join
 
Charlz
Gold member
posted
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 !


WF 7.6.4 & 5.3
Charles Lee
 
Posts: 93 | Registered: June 17, 2008Report This Post
Zippo
Member
posted Hide Post
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
 
Posts: 12 | Location: New Yawk | Registered: February 16, 2006Report This Post
Charlz
Gold member
posted Hide Post
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...


WF 7.6.4 & 5.3
Charles Lee
 
Posts: 93 | Registered: June 17, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ODBC MS Access causes Syntax error in FROM clause

Copyright © 1996-2020 Information Builders