R
Ron Hinds
I'm upsizing the BE of an A97 DB to SQL2K. One of the tables which appears
to have upsized correctly, i.e., the text field sizes are the same as they
were in the original DB, is giving me an error when I open the linked table
in Access:
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data. (Error 3163)"
When I open the table in Design view in Access, all of the text fields are
set to a length of 255. But in the original table, *most* of the text fields
were set to a length of 50. I've determined the offending field is one
called Comments, which *was* set to a length of 255 in the original table. I
execute a SELECT against this table in Query Analyzer, then copied the text
from the Comments field of a record that shows #Error# in Access to the
clipboard and pasted it into a text editor. It has the full 255 characters
but no more.
BTW, this is the only table out of several hundred that this happens on. I
tried deleting and re-linking to no avail. What could be going on here? TIA!
to have upsized correctly, i.e., the text field sizes are the same as they
were in the original DB, is giving me an error when I open the linked table
in Access:
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data. (Error 3163)"
When I open the table in Design view in Access, all of the text fields are
set to a length of 255. But in the original table, *most* of the text fields
were set to a length of 50. I've determined the offending field is one
called Comments, which *was* set to a length of 255 in the original table. I
execute a SELECT against this table in Query Analyzer, then copied the text
from the Comments field of a record that shows #Error# in Access to the
clipboard and pasted it into a text editor. It has the full 255 characters
but no more.
BTW, this is the only table out of several hundred that this happens on. I
tried deleting and re-linking to no avail. What could be going on here? TIA!