I got this done using pass-through query, I'm now able to retrieve data from
DB2 and speed seems good. My pass-through query looks like this:

SELECT *
FROM OPENQUERY(TSTESA5, 'SELECT * FROM DON1.ETAX_W2')
where W2_FIDN = '68052889600'

TSTESA5 is the linked server name
ETAX_W2 is the table
W2_FIDN is column


Amir



"Armen Stein" wrote:

On Mon, 12 Apr 2010 07:32:01 -0700, DrEvil
wrote:

I'm not sure how to set-up ODBC connection to MSSQL 2005 ent. to show linked
server tables

So you're saying you can link to normal SQL tables from Access, but
you can't see the linked SQL tables in the same database? I don't
understand. Maybe someone else can clarify why this wouldn't work.

Another approach is to build SQL views on the remote DB2 tables and
link to those from Access instead...

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

.