undefined name in pass-through query

I'm writing a pass-through query joining a table from within the existing
database to an ODBC linked table via DB2. I keep getting the following error:

[IBM][CLI Driver][DB2] SQL0204N "ODWOWN01_MY_TABLE" is and undefined name.
SQLSTATE=42704 (#-204)

This is my first shot at a pass-through query, so forgive my ignorance. Any
assistance would be greatly appreciated.

"Angie" wrote in message
...
I'm writing a pass-through query joining a table from within the existing
database to an ODBC linked table via DB2. I keep getting the following
error:

[IBM][CLI Driver][DB2] SQL0204N "ODWOWN01_MY_TABLE" is and undefined name.
SQLSTATE=42704 (#-204)

This is my first shot at a pass-through query, so forgive my ignorance.
Any
assistance would be greatly appreciated.


As I understand it, the pass-through query is processed entirely by the
server database, without any intervention by the JET database engine, so
your pass-through query can refer only to objects that are visible to the
server. You can't include a local JET table, as that is not visible to the
server.

--
Brendan Reynolds