0 Replies Latest reply: Jun 20, 2014 9:16 AM by M.R. RSS

    ODBC linked table issue in MSAccess - possible ODBC driver bug

    M.R.

      I am using ODAC 12c Release 2 32-bit (latest) to connect to an Oracle 11g R2 database from MSAccess (Office 2010) 32 bit.

      I created an ODBC linked table in Access. What I noticed is that when renaming a column in Oracle and then refreshing the linked table in Access (using Linked Table Manager), the changes are not picked-up.

      So I have a table partitioned by range and changed a field name from UNIQUE_CUSTOMER_MAPPING_ID to UC_MAPPING_ID. This is a VARCHAR2 data type.

      Access will not refresh the column name and return an error saying this is an unknown field, I had to delete the table and re-add it.

       

      What is weird is that I never had this problem before. It occurred after I changed the table partitioning.

       

      Before it was by an integer:

        PARTITION BY RANGE (import_id) (

        PARTITION p0 VALUES LESS THAN (2),

        PARTITION p1 VALUES LESS THAN (3)

       

      After it was by a date:

      PARTITION BY RANGE (start_date)

      INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))

       

      Must be a bug in the ODBC driver, can anybody reproduce this problem?

       

      Thank you,

      M.R.