Forum Stats

  • 3,816,115 Users
  • 2,259,144 Discussions
  • 7,893,390 Comments

Discussions

ODBC linked table issue in MSAccess - possible ODBC driver bug

M.R.
M.R. Member Posts: 36

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.

This discussion has been closed.