error seen when connecting to JDE via MSCAcces / ODBC

Our users use MSAccess to link to JDE tables via ODBC.

As of late, linking to some tables are rendering an error.

example: when trying to link F4211, we see the following:

Invalid Field definition ' SDKITID' in definition of index or relationship.

I'm able to connect to other tables, for example, F0101, with no issues.

any idea what could be triggering the message above ?

thanks,

PS: The database is AS/400

According to IBM's website, the MSAccess query may succeed the first time it is run on the database file and the mentioned error occurs on subsequent attempts.

This and other Microsoft errors may be received if the iSeries database file exceeds any of the limitations of the Microsoft Access link table manager.

For example, the MSAccess limit for the number of fields in a table is 255. Limit for number of fields in an index is 10.

To get a list of limitations, use MSAccess Help and search on "specification".

Hope this helps.

Thanks for this feedback, I will research your suggestion.

Interestingly enough, when opening the table from Pristine environment - it links and opens without any issues.

In E1 9.0, the F4211 has 266 columns.

KITID is column 261. Seems consistent with the 255 limit observed above.

Can you check how many columns are in PRIST? Maybe this has fewer columns from a prior release?

Chris - www.reportsnow.com