Re: DBA TABLES visible via ODBC

Hi,

   I assume you are using ODBC to link these tables  

   If you don't see SYS tables in Link tables window

        then You need to get permissions from your Oracle DBA    If you are getting this error

       "There are several tables with that name. Please specify owner in the format 'owner.table'"

   Then try using the following code

Private Sub link_sys_tables(sys_table_name As String)

   Dim db As Database
   Dim td_link_table As TableDef    

   Set db = CurrentDb()
   'with the assumption that All these VIEWS are owned by SYS

   Set td_link_table = db.CreateTableDef(sys_table_name)    td_link_table.Connect = "ODBC;DSN=;UID=;PWD=;SERVER=;" 'PROVIDE ODBC INFO HERE
   td_link_table.SourceTableName = "SYS." & sys_table_name 'This is source table name in oracle

   db.TableDefs.Append td_link_table                       'e.g. DBA_USER

'Call the above procedure

   link_sys_tables ("dba_users")

Hope it helps :-)
Sarma Kambhampati
PS: Better solutions? please let me know :-)

peter van alphen <peter.van.alphen_at_bigfoot.com> wrote in article <382294B0.51B5B1D7_at_bigfoot.com>...
> Hello,
>
> Is it possible to see the DBA, SYS, USER tables/view via an ODBC
> connection with MS ACCESS to an oracle7 database.
>
> Thanx in advance.
>
> Peter van Alphen
> peter.van.alphen_at_bigfoot.com
>
>
Received on Fri Nov 05 1999 - 18:30:08 CET