Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ODBC table-size limit

    Is there a limit to the size of a table when linking Access 2010 to Oracle using the Microsoft ODBC Driver for Oracle OR the Oracle 10G ODBC driver?


    Thanks
    Richard

  2. #2
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Midwest, USA
    Posts
    108
    Thanks
    5
    Thanked 5 Times in 4 Posts

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    This article looks at the Microsoft driver - Limitations of Microsoft Oracle ODBC driver. I don't think are are any significant limitations in the specifications for ODBC with regard to the size of the linked table. However there are some significant performance issues if you want to return and entire table for some reason. We routinely work with multi-million row tables, but in general we request a few rows from the table, and the real work is done in the database engine with subsecond response times.
    Wendell

  4. #4
    New Lounger
    Join Date
    Jun 2013
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    There shouldn't be, unless you're using the free express version (which has a database size limit - and this applies to MS SQL Server Express as well). Some Oracle ODBC drivers are not very well behaved, so if you have problems can you try another driver?

Posting Permissions

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