Microsoft KB Archive/163894

= BUG: Linked Table Shows Incorrect Field Size =

Article ID: 163894

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q163894



BUG #: 11462 (WINDOWS: 6.0, 6.5)



SYMPTOMS
Sp_columns returns incorrect information regarding the precision of fields in a view if the fields are concatenated, calculated, or derived. If Microsoft Access links to such a table, it receives incorrect information regarding the size of the field. Tables created from linked tables with a Make Table query in Microsoft Access truncate the data.



CAUSE
When a view is created, it correctly adds the lengths of the fields together, but it uses the precision of the first field named in the concatenation. Fields in the view that are calculated or converted from other datatypes may also show incorrect precision. When Microsoft Access links to a view and queries sp_columns, it receives incorrect information about the column.



WORKAROUND
To copy a linked table while in Microsoft Access, create a new table structure in Microsoft Access with the fields set to the correct size. Use an append query to move the data from the linked table to the new table.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: attach attached import

Keywords: kbbug kbinterop kbusage KB163894

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.