I have a simple single table MS- SQL 2000 database which I would like to connect to and update from MS-Access. I have established the appropriate project with a link to the SQL database and I can view the table just fine. However, when I try to update any field I get "This Recordset is not updatable".

What parameters do I need to change to be able to edit the SQL data?