I have an MS Access db with a linked table pointing to an MS SQL server database view. We have been using MS Access as a simple front end to change data contents via this view. The view was referencing only one table so it worked smoothly, we had no problem.
Now, I got a request to put in a field into that view that is from another table. The new field should serve only informative purpose, there is no need to update it, only the contents of the original table.
My problem is that if I put this field into my view (joining the other table in the view) I am unable to update the row in MS access because I am getting an error message:
"The record has been changed by another user since you started editing it. If you save the record you will overwrite the changes the other user made."
I am having a similar error message if I try to delete. Only inserting a record works.
I understand that this happens because SQL server and Access both try to modify the record. My question: is there way to make this work somehow?
I would really appreciate the help! Thanks