Wondering if you can help with a problem with topic Linking to a table from Access to another database via ODBC.

I have been able to create a successful ODBC driver link from Access DB to an Oracle 9.x DB using Access > Get External Data > Link Tables.

However, the list of tables returned is not the full list (table list gets truncated) and unfortunately, the tables I need to join to do not show on the list (would be further down than the bottom of the list).

Do you have any ideas how I can still link tables via ODBC when tables do not appear in the list?? Is there anyway to point to a specific table when connecting, excluding all others??