Re: How to get to the Oracle system table names with ODBC in Access

Sys.All_Tables is actually a view so I don't think that you will be able to access it that way. I tried creating a link to the view from MSAccess 2000 and was not able to see it.

Maybe knowing it is a view will help some more.

Regards
Jon

NoSpam_at_NoSpam.com (NoSpam) wrote in
<957a1a$5cq$1_at_ih292.ea.unisys.com>:

>I'm using ODBC with MsAccess to read an Oracle system table
>(something like SYS.ALL_ALL_TABLES) in order to get to the DB data
>dictionary. The ODBC connection works all right with other user
>tables but it just doesn't work with system tables. What I'm trying
>to do is this:
>
>Set rst = dbs.OpenRecordset("SELECT * FROM SYS.ALL_ALL_TABLES",
>dbOpenForwardOnly)
>
>Access ODBC mistakes it as SYS.MDB and reports the table missing. I
>realize the "." is translated to "_" when Access links to an Oracle
>table. Then I use SYS_ALL_ALL_TABLES but it still say
>"SYS_ALL_ALL_TABLES table not found". Just how can I read a system
>table from Oracle?
>
>
>TIA
Received on Tue Jan 30 2001 - 23:18:10 CST