Solved

Linking problem with Z/OS DB2 tables in MS Access

Posted on 2007-03-19
8
321 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
8 Comments
 
LVL 37

Expert Comment

by:momi_sabag
Comment Utility
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:Kdo
Comment Utility

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
Comment Utility
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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 37

Expert Comment

by:momi_sabag
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
PAQed with points refunded (125)

Computer101
EE Admin
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

771 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now