There are a number of ways to work around this Oracle problem. When possible, change the Access Memo field to a Text field with a length of 255 or change the Oracle Long data type to VARCHAR2(2000). A more complicated, but rigorous approach is to create separate tables, one to hold each additional OLE Object or Memo field. Each additional table will contain only two fields, a Counter field as the primary key and an OLE Object or Memo field. Designate fields in tables that require OLE or Memo data types as Long Integers with Unique Indexes that are Required. When a new OLE or Memo field is needed, insert the field value in the OLE or Memo table and use the newly created primary key as a pointer to the OLE or Memo field value. This will allow unlimited numbers of OLE Object and Memo fields per table, however, a design change is required.
With Oracle8, set the default OLE Object data type to BLOB and change the Memo data type to either VARCHAR(4000) or CLOB.