[R] RODBC and Very long field lengths

[tom wright]

I'm having a small problem using RODBC. I'm trying to retrieve a string
from a very long memo field (512*20*9=9360 characters = 74880 bytes) in
an MSAccess database. 
It appears that RODBC set a maximum buffer size for a single column of
65535 bytes.

########## cut from RODBC.c ##########
	} else { /* transfer as character */
	    int datalen = thisHandle->ColData[i].ColSize;
	    if (datalen <= 0 || datalen < COLMAX) datalen = COLMAX;
	    /* sanity check as the reports are sometimes unreliable */
	    if (datalen > 65535) datalen = 65535;
######################################

Can I increase this by just changeing the value in RODBC.c? If so how do
I get R  to re-compile the package?

Thanks for your advice 
Tom