Copy and paste linked table structure only, then change data field type for a column

Hi there - the issue is not the structure of the query, but the data. It seems to me that I cannot edit/update the data when accessed through a query. Or perhaps I am just doing something wrong?