?
Solved

MS Access ODBC Connection to AS/400 Problem

Posted on 2003-03-29
5
Medium Priority
?
253 Views
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.
0
Comment
Question by:chuckwood2002
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

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

Author Comment

by:chuckwood2002
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.
0
 
LVL 18

Expert Comment

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

Author Comment

by:chuckwood2002
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.
0
 
LVL 18

Accepted Solution

by:
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.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Implementing simple internal controls in the Microsoft Access application.
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…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

592 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