This content has been marked as final. Show 2 replies
I can't reproduce your issue.
Have you double-checked that the tables MSysAccessObjects, MSysACEs, MSysObjects, MSysQueries and MSysRelationships are visible and that the Admin user has at least Read Design and Read Data permission on those tables?
If that is the case, and the problem still happens, and you are able to give a copy of your .mdb file to Oracle, then I suggest to open a Service Request with Oracle Support so that the issue can be investigated.
Sorry for not posting this before. After a couple of days I did find the reason of the "Invalid Relation" error.
It was because the Access database contained a table that had a foreing key with an exteranal table. The table that stores the primary key was a linked table that remains in a different .mdb file and that was not accesible.