I am having a little difficulty linking tables in MS Access 97. I have configured the ODBC datasources and can link to all tables in one schema of the DB2 UDB that I am trying to connect to. I was only able to make this work by changing my registry entry HKEY_LOCAL_MACHINE>>Software>>Microsoft>>Jet>>3.5> >Engines>>ODBC>>AttacableObjects to 'TABLES' from the default setting of 'TABLE', 'VIEW', 'SYSTEM TABLE', 'ALIAS', 'SYNONYM' .
Does anyone have any ideas on what might be causing this to happen or how I could have the ODBC connection display the other types of DB objects? ie 'VIEW','SYSTEM TABLE', 'ALIAS', and 'SYNONYM'