Memo field limitation?

[Julian Milano]

I just tested a database with a memo field and found that the field
limitation is 57,816 characters. Is this correct? Is there any way to
increase the field size in Access?

 

[JohnFol]

From the help screens. .. .
"A Memo field can store up to 65,536 characters. "

 

[Van T. Dinh]

From A2K Help:

65,535 when entering data through the user interface;
1 gigabyte when entering data programmatically.

Check keyword "specification" in Access Help and you get other limits.

 

[Julian Milano]

Thanks Joseph, John & Van.

--


Julian Milano

From A2K Help:

65,535 when entering data through the user interface;
1 gigabyte when entering data programmatically.

Check keyword "specification" in Access Help and you get other limits.

 

[wibbler]

OK!! I found the answer!!!

The problem appears to be with the way the import routine works... instead
of looking at the table and seeing that the field is a MEMO field, it must
interrogate the first few lines in the input file, and "guess" at the field
type. I found someone's suggestion in another newsgroup to modify the input
file to have the record with the long entry appear first in the file, tried
it and magic, it now works!!

Cheers,
wibbler.