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.