Money field different in Access and SQL Server??




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!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question