Question. I am trying to connnect by MS Access .mdb through ODBC to a
UDB / DB2 database. I installed the DB2 runtime client and fixpack. I
can create the ODBC data source, connect it through MS Acess, and
actually see the db and tables that I am trying to link to in the
remote db2 database.

However, when I try to open the table, it gives me an ODBC error and
shows something like a #name? for each field of data. What is weird is
that is hows me the table structure, if I go into design view and
actually returns the correct # of records.

I wonder if there is some user settting in db2 that is preventing me
from reading the database through ODBC.

Anybody know what the problem is and how to fix it?

Thanks.

DjH