ODBC Links to AS400

[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.

 

[Rick Brandt]

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.

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.

 

[Connie Wilson via AccessMonster.com]

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.