I received this error message:
"This recordset is not updatable"
I was trying to edit my fields in the subform in Access the recordsource is a table which resides on SQL Server. I checked the locked property of the control and form objects they are set to 'no' or false. The recordset type property of the form is Updatable Snapshot. So the problem must lies in table definition. How can I check if that is the problem? I'm new at MS SQL Server I would appreciate any help.
Originally posted by machado
YOu did not mention If you are using ODBC or an Access Project file.
You can check one of two things.
1. The user specified in the SQL Connection has read and write permissions.
2. That the table you are trying to edit has a primary key.
Thanks for your reply.
I'm using an Access Project file. I checked the table, it has an id field and the identity column is checked and value is incredment by one. Why couldn't you edit fields of a table with a primary key? How do I check for permissions in The SQL Connection? Would it be in the code?