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