Linked Table in Microsoft Acess Results in Duplicate Records (Doc ID 1371290.1)

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version: 9.2.0.1 and later   [Release: 9.2 and later ]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Symptoms


Linking an Oracle table in Microsoft Access results in a record being repeated when duplicate records do not exist in the table, whereas the table contents are displayed correctly if the table is imported.

Additionally, a symptom may be that you receive the following error message in a popup dialogue in MSAccess when trying to update data.

The data has been changed.
Another user edited this record and saved the changes before you attempted to save your changes.
Re-edit the record.




The behavior can be reproduced with the following table:

drop table testduperows;

create table testduperows (
col1 varchar2(10) not null,
col2 varchar2(10),
col3 varchar2(10));

create unique index idx_1 on testduperows (col2);
create index idx_2 on testduperows (col1,col3);

insert into testduperows values('one',null,'r1c3');
insert into testduperows values('two',null,'r2c3');
insert into testduperows values('three',null,'r3c3');
insert into testduperows values('four',null,'r3c4');
commit;



When linking the table in MSAccess, the first row will be shown 4 times:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms