Unfortunately, we have users that like to use other applications to access our Oracle JD Edwards EnterpriseOne (E1) data.  I say, "unfortunately", because when users view data outside the application, you never really know if what they are looking at is really what they want to see.  Of course, this is dependant on the expertise of the user.

Anyway, we found a limitation on one of our users favorite little helper applications, Microsoft Access.  There is a limit to the number of indexes a file can have that MS Access links to.  That limit is 32.  Which, in most cases is plenty.  Our F06116 has 32 indexes, but was still not able to be linked to.  I think it is because MS Access counts the actual file as one of the indexes.

Hope this helps someone else dealing with Oracle JDEdwards EnterpriseOne (E1) file access with Microsoft Access.

Here are some other Microsoft Access limitations.