More than 10 primary keys

[James]

Hi,

I have linked (ODBC) tables (from Iseries) to Access, however, in
iseries the table has 14 primary keys and Access only allows a maximum
of 10. What is recommended? Thanks.

 

[Rick Brandt]

Hi,

I have linked (ODBC) tables (from Iseries) to Access, however, in
iseries the table has 14 primary keys and Access only allows a maximum
of 10. What is recommended? Thanks.

If you are in a position to do so you can make a view or logical file
against the physical file on the ISeries and link to that instead. I'm not
sure that will solve the problem, but you can try it. There might even be
existing logical files or views you can test on.

 

[James]

If you are in a position to do so you can make a view or logical file
against the physical file on the ISeries and link to that instead. I'm not
sure that will solve the problem, but you can try it. There might even be
existing logical files or views you can test on.

Thanks, you pointed me in the right direction. I don't have that type
of authority to create one, but there are some (logical files)
existing. I found one that had 11 primary keys. I'm getting closer
but no cigar. I hope this doesn't come back to bite me. Thanks.