The field is too small to accept the amount of data you attempted to add...?

[robblack]

All,
I have inheirited a database which I am attempting to query via an SQL statement:

"SELECT * FROM MYTABLE ORDER BY SheetNumber;"

This query works fine under Access but when executed thru ADO 2.5 / Microsoft.Jet.OLEDB.4.0 from VB6 it reports the following error ("2147217833"):

"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."

First things first, I'm not trying to add/insert/paste any data (see SQL statement above). Secondly, when I remove "ORDER BY SheetNumber" from the SQL statement the error does not occur. I need to retain the ability to sort and would be grateful for any help/suggestions.

For your reference SheetNumber is defined as a 20 char Text field in Access.


Thanks in advance,


Rob Black.

 

[robblack]

Having tried many things (including extending SheetNumber chars to 255), I eventually discovered some erroneous symbols within the SheetNumber field of a particular record. I've no idea how these characters made there way into the database (corruption?) but having updated the offending field, I'm please to say things are now working as intended.


Thanks.


Rob.