Maybe I was't all that clear.

Let me expand on the problem.

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 was wondering if I need to us an openquery or openrowset in the statement.

Thanks for the help on this.