Linking a SQL Server 2000 table using ODBC into Access 97
database cause a change from number to text for those
fields in the SQL Table defined as numeric with length of
9 precision 17 and scale 2.

Thanks in advance

Hi JD,

This is expected behavior in Access 97. Access 2000 (and later versions)
have the Decimal data type in Jet, which will allow for this conversion
between the SQL data type and the Jet data type. Since Access 97 does not
have the Decimal data type, it defaults to Text.

Best Regards,

Rebecca Casselman MCDBA, MCSA, MCSE NT4/2000
Microsoft Online Support Engineer

Get Secure! - www.microsoft.com/security

================================================== ===

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.