Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Question Unanswered: Access can't see Oracle table and Data

    When I link the oracle table using MS Access, some tables can't be seen and certain table record can't be seen as well ?

    What's the problem ???

  2. #2
    Join Date
    Jan 2004
    Location
    Melbourne, Victoria, Australia
    Posts
    6
    Sorry - no answer - more questions:

    Are you getting any errors? Which versions of Oracle/MS Access? Is the user defined in the ODBC connection owner of the tables that are not visible? If not, can you see those tables when you log on to Oracle as the user that is configured for ODBC access?

    Kind regards

    Kresimir Fabijanic

  3. #3
    Join Date
    Nov 2003
    Posts
    6
    I am using orale 8i and MS Access 2000.

    The user that I'm using are the same for both login.

  4. #4
    Join Date
    Jan 2004
    Location
    India
    Posts
    62

    Thumbs up

    What happens when to log on to oracle for the user ? Can you see the tables and the data ? If not, it means that the user does not have the previleges to see the tables and / or the data.
    In this case you will not be able to see it from access also.
    Is this the case. Check.
    Regards,

    Rushi

  5. #5
    Join Date
    Nov 2003
    Posts
    6
    If I log on using user using TOAD, I can see the data and table except for MS Access.

  6. #6
    Join Date
    Jan 2004
    Location
    Melbourne, Victoria, Australia
    Posts
    6
    Hi

    From your postings I will assume:

    - You are not getting any errors
    - You are running Oracle 8i (anything from 8.1.5.0.0 to 8.1.7.4.11) [BTW Are you aware of OS that Oracle runs on (Unix, Windows, ...)?]
    - You are running Access 2000 on your computer
    - You are running TOAD
    - Logged as the same user, TOAD can see the tables that Access can't.
    - You do not seem to be aware if the user you are using is owner of the tables or not.

    Few questions:

    Q1 - can you check your settings of the ODBC connection?
    Q2 - can you set the ODBC logging on your PC?
    Q3 - do you see the tables that you can't see in Access in the TOAD schema navigator?
    Q4 - If you do - is the schema owner same as user?
    Q5 - (I appologise if this question seems insulting, it is not intended to be) Did you, by chance, look for the <owner>.<table name> under different usernames/owners?
    Q6 - logged in TOAD issue following query in SQL Window:

    select * from all_objects where object_name = '<the name of one of the tables you can't see [uppercase]>'

    and please, post the answer.

    HTH

    Kind regards

    Kresimir Fabijanic

Posting Permissions

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