MS Access ODBC Connection to AS/400 Problem

Posted on 2003-03-29
Medium Priority
Last Modified: 2012-05-04
When I link a table whith an ODBC connection (DSN) using the Client Access ODBC driver and connect to the ARCUST file (table) on the ARDATA library (database), ODBC connects to ARDATA.CUST with no problem. When I try the same thing using a library named ARDATA.341 (ARDATA.341.CUST), Access gives the error "The Jet database engine could not find the object 'ARDATA.341.CUST'. Can you tell me how to work around this problem (bug)? Sorry for the low points but I just got this job and cannot afford to buy more points right now.
Question by:chuckwood2002
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
  • 3
  • 2
LVL 18

Expert Comment

ID: 8237996
Create a second ODBC connection for the second library.  that should fix things up!

Author Comment

ID: 8238594
The problem is that I get the "could not find the object" error when I try a second ODBC connection. The problem seems to be that there are two periods (.) in the object ARDATA.341.CUST.
LVL 18

Expert Comment

ID: 8239039
Might well be.  When you link, does it bring the 'table' into Access?  If so, try renaming the linked table (alias it).

Author Comment

ID: 8239618
When I try to link the table, it shows the path of all files (tables) in the dialog box but, when I select one, it gives me the "could not find the object" error and no table is linked.
LVL 18

Accepted Solution

1William earned 225 total points
ID: 8239974
Only other thought I can give  (Being I am not a AS400 wiz) is a soluition I had to do a while back.  I had the AS400 admin crreate a 'view' for me that I was able to see and link to.  In this case, one that has a name (which appears to be the problem) that meets convention.

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

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
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
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.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

762 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