I have a Microsoft Access database which is already linked with many tables in Oracle. I want to add few more tables to that from different server of Oracle.
If I connect to the server through Microsoft Access and try to import using the linked table manager, I can't find my schema or user in that list of tables.
How do I achieve this? Why are my table schemata not listed in this, even if I connect to the right server?
