Thanks for everyone's suggestions. The DDL query run after the relink works fine and restablishes the unique index, and that fits in perfectly with how my other structure is set...

There are unique values in all of the tables within the view. The problem stems from the view being able to distinguish which is the primary index. This is set...

OK - in answer to my own question and for the benefit of others who may have the same problem - I managed to solve it!

The problem does indeed stem...

Nope, that didn't work either. I didn't actually notice any difference!

Initially it works perfectly within Acess - you can add and edit.

As soon as you relink it it becomes read only,...

As it is a fresh link it works fine! When I attach the table using Get External Data and choosing the ODBC source, it then pops up a box asking for...