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

[Quoted] [Quoted] I'm using ODBC with MsAccess to read an Oracle system table (something like [Quoted] SYS.ALL_ALL_TABLES) in order to get to the DB data dictionary. The ODBC [Quoted] 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 [Quoted] 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 Wed Jan 31 2001 - 00:22:39 CET