Linked Oracle Tables In Access anyone done it ?

[marduk2002]

Hello,
I open Access 2000 and Go to link to a Oracle Database.
I connect through a ODBC Driver using my System ODBC Connection that works with other programs (Crystal Reports) when I get the option to select the Tables The tables i need do not show up...I.E I see a whole bunch of Tables but none of them are of the Type "System." I see the Public and Scott ones but no System...This also Happens when I use VBasic VisData but using Crystal reports I can see the Tables....Any ideas ?

Thanks

 

[scking]

Yes, have you set the option to see the system tables?

tools\options\view\system objects

Steve King Growth follows a healthy professional curiosity

 

[marduk2002]

Thank you so much.....That has made my day