Numeric Field Overflow problem (TOP URGENT)

  • Thread starter Thread starter Samer
  • Start date Start date
S

Samer

hi all, i have many append queries (for linked spreadsheet) in my
database that were running okk and very normal. suddenly i opened my
database and all of them are giving me this error message although
they were executed many times before. sometimes, it cannot add records
because it considers all the records have the same value (the error is
because of key violation) although the linked spreadsheet is ok and
the values are correct and not equal ... any help??? this is top urgent
 
It is not evident WHICH error you got. The title mentions something
different than the text body.


Overflow is generally a division by 0, or exceeding 255 in a byte field, or
the limit of a small integer ( such as computing 24*60*60 as short integer),
etc. The solution is to remove the records with the 0 as divisor, or to
increase the capacity of the computed expression, such as 24*60.0*60 or
24*CDec(60)*60, or in the table design (for the implied field).

Key violation is NOT having a required parent defined in another table.
Example, if you try to enter a record with value of UAS, as country value,
but , in table of Countries, you don't have UAS, that will create a key
violation (and you should then see that there was a typo, should be USA, not
UAS, or something similar). The solutions is either to correct the mistake,
or to add the new 'parent' in the parent table.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top