The problem:
"Update or insert of view or function 'function_name' failed because it contains a derived or constant field (#4406)"
in my access database which is linked to SQL server
The reason:
The underlying view is of type "union"
The solution:
change to a single source (not a union select)
