Linking an oracle table with a non-unique index

[SadOldGoth]

Hi Folks,

I'm linking to an oracle database through ODBC and want to update the table. I'm getting the message 'Query must use updateable recordset' when I run an update query on it.

I think - and am fairly positive - that the cause is that looking at the index definition on the oracle side it shows that the index is based on a non-unique primary key. However, I cannot link to the table and replicate that index type. I can link and NOT have an index at all - that's not what I want. I can link and have an index based on UNIQUE values, but that's also not what I want. I need to be able to set up an index where the primary key is non-unique.

Can anyone help?

Later,

Jes

 

[SadOldGoth]

Hi Folks,

Sorry, I'm talking nonsense and you probably know it ;0)

I've taken a look back at the tables and linking them with a primary key gives me unique values, linking them without a primary key gives me non-unique values - the end result is still the same though, I can't update the table.

It's not an issue of security - If there's only a single record for each primary key, it'll update, but falls on it's butt if there's more than one.

Other tables will update fine.

Any ideas,

Later,

Jes