DOC: Additional Jet Database Record Size Information

MORE INFORMATION

The Microsoft Jet Database Engine Programmer's Guide, Appendix A, documents that Microsoft Jet stores MEMO and OLE fields on separate pages (Long Value pages) from the rest of the record. And that for every non-NULL MEMO or OLE field, there is a 12-byte overhead in the main record that points to the location of the start of the Long Value page chain.

Appendix A, however, does not document that Microsoft Jet 3.5 and earlier will attempt to store the MEMO or OLE value in the main record if the size of the data is less than or equal to 32 bytes. This results in faster lookup of these values and does not incur an additional 2K storage overhead, but does retain the 12-byte overhead. If the record is very large, (approaching 2000 bytes for example, the maximum record size), the MEMO and OLE fields will be stored in a Long Value page even if 32 bytes or less.

For Jet 4.0 (VB6.1, Office 2000), this limit is increased to 64 bytes (not 64 characters).

Also for Jet 4.0, the page size is increased from 2K to 4K and the maximum record size has increased to approximately 4000 bytes.