Memo field limitation?

  • Thread starter Thread starter Julian Milano
  • Start date Start date
J

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?
 
I believe that is the Access editor's limit, not the field limit. I
understand it is possible to edit the field using other than the Access
editor.

Sorry I don't know more, but I have found the Access memo fields so
unstable that I do everything possible to avoid them.
 
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.
 
Thanks Joseph, John & Van.

--


Julian Milano

Van T. Dinh said:
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.
Click to expand...
 
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.
 
Back
Top