I have three tables; two are local, and one from the AS/400.
I link all these table in a query, and there is a message say that “Record not updatable”.
When I remove the table from the AS/400, and leave the two local table it does allow me to change any record I want.
I do have permission to write to the AS/400 table. I will not let me update the record only when I connect these three tables together.
Explanation or help are much appreciated.