Solved

Linking problem with Z/OS DB2 tables in MS Access

Posted on 2007-03-19
8
331 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:DSchat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 18748338
Hi

maybe this is a bit far fetched but did you check that there is an actual table with that name ?
maybe it's a view and when access try to link to it, it also links to the base tables ?
0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 18748531

Hi DSchat,

Are the table names that you're seeing really tables or perhaps they are associated aliases/nicknames?  It could be that DB2 is following the alias/nickname to the target table.

If not, check to make sure that you have the latest ODBC driver on your Windows server.  Simply uninstalling it and reinstalling it should be fine.


Good Luck,
Kent
0
 

Author Comment

by:DSchat
ID: 18754429
Hi,
The table actually exists, it is not a view. I've never tried to link a view, but what is happening isn't consistent with that theory, because Access is trying to link literally hundreds of tables which are all being listed.
The ODBC driver is DB2 Connect version 8 with FP 12. Not the newest but only six months old. As far as DB2 is concerned, I believe that the level is relatively actual. The terminal server where the software is running was just recently installed. I have the same software configuration on my local computer and there the problem does not occur. I can link the table I want.
0
Create CentOS 7 Newton Packstack Running Keystone

A bug was filed against RDO for the installation of Keystone v3. This guide is designed to walk you through the configuration for using Keystone v3 with Packstack. You will accomplish this using various repos and the Answers file.

 
LVL 37

Expert Comment

by:momi_sabag
ID: 18754706
Hi

that sounds like a bug or something
anyways, lets try a different approach
what happens if you create a new user and only give it select authorization on the table you want to link to, that is, it does not have any autorization on any other table
now connect with that user and try to link the table,
access should not be able to link to other tables the the user does not have select authorization to

what happens ?

momi
0
 

Author Comment

by:DSchat
ID: 18754760
Hi Momi,

not a bad idea, but I can't do it. I do not have the enough rights on our host system to try that. One other point along the same lines. This problem happens when I try to link the table with my sort of admin user and also several users have complained that they having it as well with their reduced rights. Theoretically the users are the creators of the problem tables and then the only authorized readers except for admins on the system.
0
 

Author Comment

by:DSchat
ID: 18929893
We found the error. I set the AttachableObjects key in the the Jet Engine section of the windows Registry to 'TABLES'. Apparently Access has a problem when the number of object too high is.

Please close question and refund the points.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 19526898
PAQed with points refunded (125)

Computer101
EE Admin
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question