Overflow Error - What does it mean?

[itlee]

Hi,

Does anyone know about or has come across Overflow error's in Access?

I can't find anything in MS KB. I originally got the error when trying to divide one recordset field (tabletype) by another, where the values were 0 (zero). I fixed that and now I get the error when using Automation with Excel, after the automation server has thrown an exception.????

Please any info or urls would be great.

Thanks

ITLee

 

[kathryn]

I have gotten it when assigning a number to a variable which is of a type that is too small.

For example, if you define a variable as a byte, it can only hold data values from 0 to 255. If you try to assign 256, you can get an overflow error.

HTH.

Kathryn

 

[scking]

An overflow error occurs when the declared type can no longer handle the size. For example, if you are using an integer to count values which are larger than the value an integer can store you will get an overflow error. An integer can store -32,768 to 32,767 values in the two bytes it uses (16 raised to the second power). Also, if you address an array value out of bounds you will get the same.

Steve King