"This Recordset is not Updatable", how to make it updatable

I am trying to update data in an SQL Server 2000 database via Access 2000 set up as an ADP.  I get the error "This Recordset is not updatable" even though all permissions have been given in the database at the database, table, and column level.  I don't see anything in the Access settings that should prevent this from working.

Help, Thanks
Who is Participating?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.