I have an Access Database 2007 that is linked to our SQL Server 2008.

In my MSA I have a Form and datasource of the form is view. User can update his userid so far without any issues. Now I have selected
a new column in the view which already exists in one of the main table. since then I started getting this error when i try to update userid using
rst.update command. As soon as I remove the column from the view and relink SQL server database again, it works just fine.

Also to note,
Update table has primary key set which is identity column. Also the recordset (rst) has timestamp column selected.

Please help.