I had this same problem with a linked .csv used in a 'make table' query, in Access 2003. Th 'make table' executed perfectly the first time after the table was linked, but returned a "Numeric Field Overflow" error on subsequent occasions.
However changing the name of the linked file, and then...