You are correct, I cannot seem to find DB2 linked tables in the list. I was
going to try passthrough query, maybe that would work.
I'll take a look at the SQL views also.
Thanks
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
.