Acceess 97 Upsized to SQL 2000 - Memo Field errors -
02-17-2005
, 09:51 AM
Hi
After upsizing..
In the access 97 front end forms, if i try to add data to a memo field i get
an ODBC error.
in SQL 2000, i've tried changing the data type of the field from ntext to
text but i still get an error.
the error is something like:
Factional Truncation #0 cannot (?????) to text, ntext or image data types
unless using IS NULL or LIKE oporator....#306
(sorry, don't have full message infront of me).
does anyone have any idea what the problem might be??
thanks
Jado |