Update Query

  • Thread starter Thread starter ChrisRel
  • Start date Start date
C

ChrisRel

Hi

I;m trying to update the fields in a table using a Query
from Access 2002

I have this message:
The field too small to accept the amount of data you
attempt to add. Try inserting or pasting less Data

Any help please about this message what this mean

Thanks
 
ChrisRel said:
Hi

I;m trying to update the fields in a table using a Query
from Access 2002

I have this message:
The field too small to accept the amount of data you
attempt to add. Try inserting or pasting less Data

Any help please about this message what this mean
Click to expand...

It means pretty much exactly what it says. Examples would be...

Trying to put a number larger than 255 in a byte field.
Trying to put a number larger than 32767 in an integer field.
Trying to put the string "123456789" into a text field less than 9
characters wide.

Look in help at the FieldSize topic and you will see the ranges of values
allowed for the various DataTypes. Your query is obviously attempting to
insert a value that won't fit somewhere.
 
Back
Top