Money field different in Access and SQL Server??

[Jerome]

Hi,

I've got the following wierd phenomenon (using Access 2000):

When entering a money value, let's say 10, into the corresponding field
on my form it saves as 10.00 in my SQL Server database but in Access it
shows up as 1000.00???

ALL numbers in the this Money column get multiplied by 100 when
displayed in the forms AND when displayed in the table (in Access) that
is linked to the SQL Server!?

So again, the value in the SQL Server DB is 10, but in Access forms and
linked tables it shows up as 1000!

Does anyone have an idea what the problem could be??

Thanks a lot!