(My first tek-tips question!)
I've created a basic MS Access 97 form for updating an attached Teradata table. The table has a column that is defined as Varchar(5000) (Originally I had it at Varchar(12500). Anyway, my problem is this: I can add a row to the table, but if I try and Update this large Varchar column in any way I get a -3944 error "Data Length is invalid for the data type."
(This situation adds new emphasis to the 'get it right the first time' addage!)
The purpose of this field is to store DDL changes to be applied for a software release, so I anticipate big text at times...
Any insight into how to address this situation would be greatly appreciated.
I've created a basic MS Access 97 form for updating an attached Teradata table. The table has a column that is defined as Varchar(5000) (Originally I had it at Varchar(12500). Anyway, my problem is this: I can add a row to the table, but if I try and Update this large Varchar column in any way I get a -3944 error "Data Length is invalid for the data type."
(This situation adds new emphasis to the 'get it right the first time' addage!)
The purpose of this field is to store DDL changes to be applied for a software release, so I anticipate big text at times...
Any insight into how to address this situation would be greatly appreciated.