Wrong display of smallmoney data in a linked SQL Server table

G

Guest

I linked a table from a German version of SQL Server 2000 in an English
version of Access 2003.

The SQL Server table includes smallmoney fields. If I access the SQL Server
table with an English version of Enterprise Manager the fields are displayed
correctly, but if I open the linked table in Access the values are all wrong.

The value 240 is displayed as 24.000,00 €. The value 1140 is displayed as
1,14 €. Even it shouldn't it seems to be a problem with the different use of
comma and period for displayig numbers in Amerika and Europe. But it might be
also a prolem wih the smallmoney data type.

Can anybody help?

Marcus
 
G

Guest

I linked the same tables into a German version of Access, but the result is
the same. there must be a major problem or a special setting.

Marcus
 

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

Similar Threads

Update Data of linked SQL Server table 3
Append data to linked SQL Server 2008 table 0
#DELETE in all fields after linking to SQL Server table 1
Sql Server linked table and NULL bit fields 2
Linked tables to SQL 1
What does linking a Access table to an SQL table mean? 2
Issue with Data Types when linking to SQL Server 2
SQL Custom Data Types Not Visible In Access Linked Tables 1

Top