For ODBC data with OLE or Memo fields use dynasets instead of snapshots
See tips #4 and #23 for more information about why this is so.