Error Message - Error No:6;

[Shuttle]

Hi. The following message appears when an append query is run in one of my databases "Error No:6; Description: Overflow". I've never seen it before, can't find it in Help - nor anywhere else on the net. All assistance greatly appreciated!

 

[rsmonkey]

how many records is the query dealing with? I've had this problem awhile back but i cant remember exactly what i did wrong I think it was something to do with a badly written sql statement dealing with a large amount of data! so post your query sql aswell!

 

[Guus2005]

Perhaps you are putting a large number (long) in a an integer field?
(sample)Database and/or query would be helpfull.

HTH