BUG: Linked Table Shows Incorrect Field Size (163894)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2003 |
|---|
| Keywords: | kbBug kbinterop kbusage KB163894 |
|---|
|