Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Linking problem with Z/OS DB2 tables in MS Access

Posted on 2007-03-19
8
Medium Priority
?
334 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 46

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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

722 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