ODBC Links to AS400

  • Thread starter Thread starter Connie Wilson via AccessMonster.com
  • Start date Start date
C

Connie Wilson via AccessMonster.com

I am linking PRMS files into Access. We use Multiplant members. When I
set up my ODBC connection, I am defaulting into the corporate member. How
can I direct my ODBC connection to our plant member? If anyone out there
has any thoughts, I would greatly appreciate them. I am stumped.
 
Connie said:
I am linking PRMS files into Access. We use Multiplant members.
When I set up my ODBC connection, I am defaulting into the corporate
member. How can I direct my ODBC connection to our plant member? If
anyone out there has any thoughts, I would greatly appreciate them.
I am stumped.
Click to expand...

You either need to create logical files or aliases *on the AS400* pointing
to the other members and then point your queres at those. SQL/ODBC looking
directly at a multi-member table will only see the first member.

Is this an old system? Most people started moving away from multi-member
files long ago.
 
Thanks Rick. Yes it is a very old system. I just started this job, and
the system is so old. I am trying to do like links into Access so I can
analyze the data. It is also been neglected. If you have any other advice
for me, please let me know. Thanks again.
 
Back
Top