Limiting Jet OLE DB memory consumption

Suppose FConnection is your TADOConnection object:

const
  SJetMaxBufferSize = 'Jet OLEDB:Max Buffer Size';

...
FMaxBufferSize := 32 * 1024 * 1024; { Limit to 32 MB }
FConnection.Properties.Item[SJetMaxBufferSize].Value := FMaxBufferSize;

You should be connected before setting the property.

Have fun,

Marcelo Lopez Ruiz