Oracle, Tables and Access

[Zurvy]

Dear All,

I'm trying to link to Oracle through ODBC...everyhting is set up, and I can connect and I can also see the tables..The problem is...there are just toooo many tables in the link window!!!....

Does anybody know how to find the right table you want faster??? Or how to limit the tables that are retrieved from Oracle to just the ones I desire?

I even set up the correct Schemas to just view the tables I want...but It won't work when linking it through ODBC!..All the tables appear over and over again... And the list is just tooo long.

PLEASE HELP! I'm getting crazyyyyy

Zurvy

 

[Pat Hartman]

Luckily you only have to link the tables once As I recall, the list scrolls by the first letter which may be some help.