error 3349 in linked table but not in local table

I'm appending data from a Table1 to a linked Table2 using a simple Insert Query ( using a VBA code). There is one field that when I include it to the query, I get a error 3349. Strangely if I make a copy of the Linked-Table2 as a local Table3 (so they have exactly the same fields and properties) and use the same query but from Table1 to local Table3 I don't get the error. Moreover if I run the insert query from Table1 to Local-Table3 and then run it from local Table3 to linked Table2, I also get no error. I don't understand why I can't get the data from Table1 to Table2 directly and It's doing it for only that specific field.