Field too small (linked table based on oracle view)

S

steph

Hi,

Working with access 2002 i've got a problem with a field in a form:
when i try to insert a new record it keeps telling me that the field is
too small for the amount of data i enter. But the length of the string
i try entering is surely not higher than the allowed fieldlength!

The form is based on a linked table which in turn is based on an oracle
view. The version of oracle is 10G. I've tried inserting into this view
outside of access and this works without any problems. The
oracle-datatype of the field is varchar2(20). Could this be a datatype
issue? What can i do to prevent this error?

br,
stephan
 
Top