Linking problem with Z/OS DB2 tables in MS Access
Posted on 2007-03-19
I am trying to link host based (IBM DB2 V8) user tables in a MS Access DB (2003) which is running in a Citrix terminal server system (W2k3). When I try to link the table I want (VOIA06.tabname) I mark it and click the OK to link it. This is where the fun starts, Access starts linking tables from a different schema with different names. These have nothing to do with the one table I want. If my table ever comes up (or will come up) is unknown to me, I have to kill Access because it wants to link hundreds of other tables. I tried to recreate the problem on a local Access installation (same version Access and DB2 Connect ODBC software - V8 FP 12) and here I don't get this problem. One interesting item is that this problem seems to occur only on tables that the user has created himself using QMF on the host system. On 'normal tables' this error doesn't seem to occur.