linked table scale problem

N

Neil

I have an access database that uses a linked table in MS SQL. The SQL table
uses a Decimal feild with a precision of 11 and a scale of 4 (7digits to
the left of the decimal and 4 to the right), however when displayed in
Access by opening the table the field is truncated to 2 deciaml places. The
field is still valid in SQL (viewed thru Query Analyzer) so why is this?
Thanks.
 

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

Problems With Precision while Linking Tables 4
Problem with ODBC linked tables in Access 2003 0
Scaling results in data truncation 2
Linked SQL table pulls all numbers as positive 0
ODBC link converting Decimal to Long Int 1
Linking ODBC table results in Decimal field size for Number type in Access 2002 1
scale of linked tables in access 4
scale in linked access table 1

Top