Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: Error linking to tables

    When attempting to link to Oracle tables via ODBC (using MS Access 2002), it returns this error:

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

    I'm using the ODBC drivers provided with Oracle client 9.2.

    Where in the process do I specify the format 'owner.table'?

    Thank you for any help you can provide.

    tex

  2. #2
    Join Date
    Jan 2004
    Location
    Venezuela
    Posts
    151

    Re: Error linking to tables

    Did you create a SYSTEM DSN ?
    Joel Pérez

  3. #3
    Join Date
    Jan 2004
    Posts
    3

    Re: Error linking to tables

    Originally posted by joelperez
    Did you create a SYSTEM DSN ?
    Yes.

  4. #4
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    instead of using select col from table change it to

    select col from schemaname.table

    You will find the schemanames (Owner) of the tables using select OWNER, TABLE_NAME from all_tables where table_name = 'MYTABLE'

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  5. #5
    Join Date
    Jan 2004
    Posts
    3
    The interface I'm using doesn't allow me to specify that. It is simply a screen that allows me to select the tables I want and click "OK" to perform the link.

  6. #6
    Join Date
    Jan 2004
    Location
    Venezuela
    Posts
    151
    Originally posted by tex416
    The interface I'm using doesn't allow me to specify that. It is simply a screen that allows me to select the tables I want and click "OK" to perform the link.
    Did you specify the user that you want to use in the DSN ?
    Joel Pérez

  7. #7
    Join Date
    Jan 2004
    Location
    Venezuela
    Posts
    151
    I think this article can help you.

    http://www.pqsystems.com/kb/question.php?qstId=47
    Joel Pérez

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •