Tie MSAccess 97 with a BBDD Oracle in version '
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Tie MSAccess 97 with a BBDD Oracle in version '

  1. #1
    Join Date
    Nov 2002
    Location
    MADRID
    Posts
    8

    Tie MSAccess 97 with a BBDD Oracle in version '

    The case is that desire to tie tables from MSAccess 97 with a DB Oracle in version 'Oracle8i Enterprise Edition Release 8.1.7.2.0', driver of ODBC that I am using is ' Oracle ODBC Driver 8.01.06.00 ',
    that is to driver that it gives to the version 8i me of Oracle client since changes it because it had the version of the 8.0.6 but they do to me both exactly the same.
    The problem that I have is that when tie/import the tables/viewes of
    this DB of oracle only allow to see the following table/view: DBSNMP.DBA_DATA_FILES
    As you can see to only displays an object of scheme DBSNMP, and I need to see everything.
    Thnaks in advance all

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sounds like either you don't have permission on the tables you need (see GRANT command) or your driver needs to be updated the 8.1.7.2 version...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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


Click Here to Expand Forum to Full Width