lewis.ray (1/29/2013)
I have an oracle linked table in an access 2007 database.I created the linked table with an odbc.
when I run the following statement I get an error saying "sytax error near from"
select column1, column2
from linked table.
I really doubt that's the actual select statement you are running. Please copy/paste both the statement and the full error message.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.