Speeding up linking Oracle tables in Microsoft Access
What if you create a special Oracle user that Access would use to connect? That user would only have the ability to access the tables that are relevant, plus it would have a synonym for every table it had access. Then when you connect from Access to Oracle, Access would only populate the table list with the tables that you want to see. I'm going to guess that you have at least tens of thousands of tables in your schema if not hundreds of thousands of tables. Are you running Peoplesoft?

You might want to find other tools to work with besides Access. There must be other BI tools that you can work with. Possibly even a few open source tools.