dbTalk Databases Forums  

Acceess 97 Upsized to SQL 2000 - Memo Field errors

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Acceess 97 Upsized to SQL 2000 - Memo Field errors in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jado
 
Posts: n/a

Default 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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.