Linking AS400 using ODBC

D

Danielle

If anyone out there could give me a hand, I'd sure
appreciate it....

I am using Access 97 to create a link to files on an AS400
system using an ODBC driver. So far, I've had no problems
doing this. I now need to link a file containing multiple
members. I can access the file member I need on the
AS400. However, when I link the file to Access the member
I need does not show up, the default member does instead,
adn that is all. I cannot figure out how to change this
setting. If I open up Excel and use Data-Transfer data
from AS/400 I am able to access this member. However,
Access is where I need it.

Thank you in advance,
Danielle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC link to AS400 in Access 2007 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
AS400 connection problems 2
Outlook linking to non default browser Edge 0
split data base using ODBC connection 1
Shortcuts in OneDrive 0
Beginner: How do I link via ODBC from a PC into an AS400? 7
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top