Max storage for memo field

[davesmith202]

Is there a difference in the max character storage capacity of an Access 2007 memo field compared to Access 2003?

Thanks,

Dave

 

[GaryPanic]

its unchanged isn't it 64,000 chars -look it up on the MS site

 

[GaryPanic]

Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048; the actual number might be smaller because of tables opened internally by Access
Table size 2 gigabyte minus the space needed for the system objects
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user interface;
2 gigabytes of character storage when entering data programmatically
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes 4,000
Number of characters in a field property setting