HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

>4K Memo field problem in Access 97	Phil Casciola	2007-05-10 09:36:03
We are having a problem inserting large strings (>4K) into memo fields in Access 97. It is very hard to reproduce, but during a large batch of inserts where we load an entire CSV into an Access 97 MDB, if we insert a string larger than 4K, we lose random inserts much further down the line and some tables become corrupted. If we do not insert any of the >4K strings, we do not have any problems.
Re:>4K Memo field problem in Access 97	HXTT Support	2007-05-10 19:24:41
Please make sure that you're using the latest package, not an older package in 2006, since v2.1.037 fixed a bug for insert very long data into JET3 version database.
Re:>4K Memo field problem in Access 97	Phil Casciola	2007-05-10 19:39:09
I should have specified that we are using the latest package, 2.1.041 Also, the problem only happens in Access 97, not with Access 2003.
Re:Re:Re:>4K Memo field problem in Access 97	HXTT Support	2007-05-10 21:23:14
>we lose random inserts much further down the line and some tables become corrupted. Whether HXTT Access failed also to query that table? Can you zip and email us a corrupted mdb file sample or your test sample?

Email: