Memo fields in MS Access don't work!

[Anon]

hi. whenever i try to retrieve data from a memo field in ms access, the text gets chopped off after about 4000 characters. does anybody have any idea how i can fix this? (i tried increasing the buffer size in the odbc manager, but it didn't let me go higher than 4096) also, are there any problems like this with non-odbc db's? thanks.

[Anon]

Author: Avishai (165.247.50.86)
Date: 2001-02-19 18:36:07

hi. whenever i try to retrieve data from a memo field in ms access, the text gets chopped off after about 4000 characters. does anybody have any idea how i can fix this? (i tried increasing the buffer size in the odbc manager, but it didn't let me go higher than 4096) also, are there any problems like this with non-odbc db's? thanks.

Hi

I have the same problem now. If you find the answer, please share it with me.

Gábor

[Anon]

in odbc on windows machine,
select the config, then hit advanced,
it has a variable called max buffer,
set it higher, like 16384

i ran into this while workin on similar prob, but i haven't tested it,
so good luck