Morning,
Thanks for replying Armen.
I'm not sure how to set-up ODBC connection to MSSQL 2005 ent. to show linked
server tables... I cannot select it from Default Database option under MSSQL
Native driver, maybe using Attach Database filename option can be utilized
for this?
Once I can get those DB2 tables to link in MS Access then its downhill from
there.

Thanks

Amir

"Armen Stein" wrote:

On Fri, 9 Apr 2010 09:44:03 -0700, DrEvil
wrote:

I have created linked server to DB2 using IBM OLE DB provider
for DB2 (IBMDADB2) and that is working, what I'm not sure of doing is linking
DB2 tables in MS Access DB.

Have you tried linking to the linked-DB2 tables in SQL Server? I
don't think Access would know the difference.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

.