Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    8

    Unanswered: Access Link To Oracle Is Missing Some Tables

    I have a microsoft access database that uses an odbc connection to link to oracle 10i tables. The window that opens which contains tables that can be linked to seems to be missing some tables. All the tables I want to link to are missing. The missing tables were created with the system login. When I login to the odbc connection I use the same login I used to create the tables(system).

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I have no experience in what you are trying to do, so this will probably be a blind shot: are those object (that are missing) tables, or - perhaps - views or synonyms? Could you specify something like this in order to make them visible to you?

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Also, you should NEVER use SYS or SYSTEM as general logins. SYS are the oracle database objects and SYSTEM is used for oracle applications. What may have happened is that your DBA discovered that illegal objects were made in the SYSTEM and schema and he removed them. Or the account is locked or the password changed.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Sep 2006
    Posts
    8
    Thanks for your response. I figured out an answer very similar to yours. It turns out that oracle by default doesn't allow tables created with the sys or system logins to be viewed or connected to via odbc.

Posting Permissions

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