I mean the fields can be updated though everyway aside from remote view, it shouldn't really fail, this is an issue with the way the odbc drivers work even if it's avoidable.

Well, it seems unlikely that the people who develop the ODBC drivers are unlikely to modify them to work the way that you think they should, so you are just going to have to make some adjustments on your end < s >.