Using DAO recordsets (from Access97), I am attempting to update a text field (in PostgreSQL) with a string. When DAO attempts to update the string, it produces the following error...
"3163: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."
The problem with this is that the string is not very large and well within the declared limits in the PostgreSQL database column. I have tried declaring the column as 'text', 'varchar(125)', and because I was desparate, "bytea".
Any string that is shorter in length seems to update fine. Here is the string...
"MARINA DEL SOL STILL BLDG NEW SALENJH CHKD MAP"
The length of this string is 46 characters.
I checked the ODBC driver configuration, but no clues.
Can you help? Thanks, I will keep working on it, but if you could provide any hint, I would appreciate it.
Gary
gwinn7
A+, Network+
"3163: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."
The problem with this is that the string is not very large and well within the declared limits in the PostgreSQL database column. I have tried declaring the column as 'text', 'varchar(125)', and because I was desparate, "bytea".
Any string that is shorter in length seems to update fine. Here is the string...
"MARINA DEL SOL STILL BLDG NEW SALENJH CHKD MAP"
The length of this string is 46 characters.
I checked the ODBC driver configuration, but no clues.
Can you help? Thanks, I will keep working on it, but if you could provide any hint, I would appreciate it.
Gary
gwinn7
A+, Network+