Linked tables Access automaticaly selects primary keys

[Martin Clark]

I use access to get data from a As400, i have linked various tables from the AS 400 but access has selected some of the fields as primary keys and won't let me take the keys off?

Is this to do with the ODBC driver or is it something in Access?

[NeoPa]

I would say both Martin.

I would guess (I'm no AS400 expert and you leave no details of what you're using to link) that the tables on the AS400 have their indices all set up and that this information is passed within the ODBC information to the driver used.

Access needs this to know how best to optimise its requests. Access has no control over the data itself so setting different indices within the linked Access tables would make no sense anyway.