Link Table Updates

[chrisjrice]

I am currently link to my AS400 DB2 Database using a linked relationship within Access. I am unable to update any of the records though Access. It keeps saying that the recordset is not updatable. I have set my ODBC driver to read/write but this still has no effect.

Can anyone help??????????????????

 

[chrisjrice]

Thank you very much for your advice. After much mucking around on Friday afternoon, I realised that I needed to have a primary key on files I wanted updating. I was initially linking to a logical view of the file through the AS400 but was not setting a key. I now link straight to the Physical file, this way access automaticaly detects the unique key.

Thanks again for your time.

Chris