Losing Key index from Oracle linked tables

[dgrady1113]

I have an Access 2007 application that has external links to an Oracle database via ODBC drivers. When the links were first established the USER ID field was a KEY field coming from Oracle. I rely on that KEY to permit updatable queries in my Access database. All of a sudden the linked table is not showing the KEY field and my update queries now have error messages. I refreshed the links but still no KEY. I tried setting the key in Design, but no changes are allowed for linked tables. I created a temporary work around by copying the linked table to a keyed access table, but there are quite a few linked tables from Oracle and it would double the size of my Access database, besides being a lot of work to keep refreshing the data in the copied table. I contacted the IT folks who maintain the Oracle DB and requested they restore the key, but they say it is Indexed already. Although I don't know much about Oracle, I saw that the Oracle Index has an "N" for the UNIQUE property. Wouldn't changing this to "Y" fix the problem? Or, anyone have any other ideas?
Thanks,
Don

 

[jackd]

All of a sudden the linked table is not showing the KEY field and my update queries now have error messages

What was done that caused this change?
Did IT change the index ?
Did someone restore a table and recreate the index with unique = n?

 

[dgrady1113]

That is what is strange. IT says that NOTHING was done to the Oracle tables and that the UNIQUE property has always been N. Some of the Oracle tables have keys and others don't. Per IT, all the UNIQUE properties say N. Again, I am at a loss to understand what happened.