sql server odbc: Change number to text linking a SQL Server 2K table to Access97 -- sql server odbc

Change number to text linking a SQL Server 2K table to Access97

JD
10/28/2003 8:10:28 AM

sql server odbc:

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.

RE: Change number to text linking a SQL Server 2K table to Access97

rebc NO[at]SPAM online.microsoft.com
11/2/2003 9:52:41 PM

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.