Oracle EnterpriseOne (E1) & MS Access

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.
Happy
Happy
0
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
0
Surprise
Surprise
0

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post EnterpriseOne (E1) & IE7
Next post EnterpriseOne (E1) ESU Investigation