Oracle EnterpriseOne (E1) & MS Access

January 2, 2008May 30, 2014

Read Time:50 Sec

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.

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

stewart@9rains.com

http://stewartschatz.com