I have an accessdatabase that imports rawdata from several tables into several databases.

The source is an Oracle database and I'm using odbc-links to connect to it in access.

I get an errormessage when I try to insert into a number kolumn:
"the decimal field's precision is too small to accept the numeric you attempted to add"

I have tried to have the column as decimal with the same precision as in the odbclink, same fault.

Any ideas as to what are causing this?