Changing primary key in Access from linked Oracle table

[Todd Piercy]

Does anyone know if you can change the primary key that
Access automatically assigns when you link to an Oracle
table via ODBC? We have an Oracle table which has two
unique indexes and Access picks the first index_name
alphabetically as the primary key but that is not the
field we want to be the key. We may not be able to change
the index_names so the Access will pick the proper field
since there may be other coding already based on those
index_names. Is there any way to manually change the
primary key or force Access to pick the one we want?

 

[GVaught]

You don't want to change the primary key value within Access as this could,
if Oracle permits the operation, change the primary key originally set in
Oracle. An Index only speeds up searches, it has nothing to do with how data
is sorted. I would create a query against the linked Oracle table and use
the query to sort how you want the data to appear. You can also use this
query against any forms within Access as long as they conform to the rules
for creating an updateable query.