Linked Oracle table is repeating data, why?


K

Koelle

I am linking an Oracle table and when I open the table in access, the first
row is repeating for all rows. The right number of records are present. Any
ideas of what the problem is?
 
Ad

Advertisements

S

Stefan Hoffmann

hi,
I am linking an Oracle table and when I open the table in access, the first
row is repeating for all rows. The right number of records are present. Any
ideas of what the problem is?
This is basically a primary key issue. I had it once, too.

I can't remember the details, but afaik you have to ensure that
Access/Jet knows the primary key of the table. So simply open your
linked table in design view and set the same field(s) as the primary key
as you have in Oracle.


mfG
--> stefan <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top