Numeric field overflow

[mike718]

I am running a update query and am getting a Numeric field overflow message. I have checked the size of the 9 fields I am trying to upload to with the location the data is coming from. And they are identical. The weird thing is if i open up the query in design view, delete a field and then add it back in it works. Does anyone have a theory as to why i keep occuring this problem??

Mike

 

[gwog]

I've got this message before too - and solved it by making a copy of the query and then renaming it to original query name overiting the original file. It works fine after that.

I too would like to know what causes it, and if there is a way to stop it with the extra work.