Field is too small to accept data

C

CS

I have converted Ms Access backend to SQL server. One of my queries fails to
run. when i click on the run button nothing happens. When i run this query
fromt he report it gives me an error"field is too small to accept data". The
query is a select query with some 30 fields.

Thanks

Chitra
 
M

[MVP] S.Clark

One of those 30 is getting a value that is too large. Probably a text
field. For example, the field is defined as Text(10), but the data coming
has a length greater than 10. If it were an issue with a number, I think
you would get the dreaded Overflow error 91.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
[email protected]
www.fmsinc.com/consulting
 
J

John Vinson

I have converted Ms Access backend to SQL server. One of my queries fails to
run. when i click on the run button nothing happens. When i run this query
fromt he report it gives me an error"field is too small to accept data". The
query is a select query with some 30 fields.

Thanks

Chitra
Click to expand...

My guess is that you may be another victim of Microsoft's abominable
"Lookup Field": your table may actually contain Long Integer ID's
(which have been duly converted to SQL/Server) while the fields SHOW
looked-up text. If you try to store the looked-up text into the
numeric ID field you'll get either this error or a data type
conversion error.

John W. Vinson[MVP]
 
Top