Solved: Datatype mismatch, Precision too small

[Imdabaum]

I have a table in SQL Server with several fields as Numeric(10,4).

When I link this table into Access it says these fields are currency. This puts some unwanted limitations on the data I am trying to import.

Anyone ever had this issue?

[Imdabaum]

Was anyone else aware that Numeric(10,4) was the same thing as a smallmoney type in SQL Server? That seemed to be the problem. All is well. Just made them Numeric(12,4) instead.

http://www.enterprisedb.com/documentation/datatype.html