Access multiplying SQL data??

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

Hi,

Following phenomenon:

I've got a decimal field in SQL Server with values like this:
5
6,45 (I'm in Europe therefore the comma)
12,03
19

Now I link to this table from Access 2000. And when looking at the table
the values in the above mentioned field are:
500
645
1203
1900

Why??? In the SQL Server table they're still displaying like mentioned
before ...

Any help is greatly appreciated.

Jerome
 
One table or the other has the field formatted incorrectly. It can be either
one. Look at the datatype and formatting properties for that field in
SQL-Server using Enterprise Manager, then look at the Access table design
view. Ignore any Access error messages warning of a linked table. (They are
there to make sure you realize that you cannot change the table from an mdb
file).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
hm, in Access 2000 the datatype is Currency and in SQL Server it's Money
....

seems ok, no?
 
Hi,

I've still got this problem that Access 2000 multiplies the decimal and
currency values from my SQL Server database x 100! Both in the linked
table view and one the forms.

Anyone got any idea what the problem could be? The regional settings on
both the server and my PC are the same, so no problem there?

The field in the SQL database is DECIMAL, in Access it's displayed as
Number/Decimal resp. MONEY on SQL and Currency in Access.

Are decimal and currency the only datatypes in SQL that allow fractions?
Is DOUBLE in Access DECIMAL on SQL?

Any help is greatly appreciated!

Jerome
 
Access supports both SINGLE and DOUBLE data types, which
allow ordinary (floating length) fractions. SQL Server has
identical types. 'Decimal' is not well supported in Access,
and not even very well supported in ODBC.

Apart form Decimal and Currency, Access has no other
fractional fixed-length, decimal, or symbolic types, although
they can by simulated by text fields.

(david)
 
Back
Top