title: 'Could not allocate memory' when inserting to a memo field in an MS-Access database with RODBC
body: <p>I'm trying to insert a new row to a table in a Microsoft Access database containing a memo field using the <code>sqlSave</code> function in RODBC, and I'm getting the following error:</p>
  
  <blockquote>
    <p>Calloc' could not allocate memory (1073741824 of 1 bytes) odbcUpdate channel query mydata coldata[m, ] test verbose nastring</p>
  </blockquote>
  
  <p>By setting <code>verbose = TRUE</code>, the last line I'm getting before the error is:</p>
  
  <pre><code>Binding: 'notes' DataType -1, ColSize 1073741823
  </code></pre>
  
  <p>It appears it's getting the maximum size of the memo field, which appears to be 1GB, and then trying to allocate that much memory. The insert works fine without changing my code if I change the type of field to 'text' in Access. Is there any way to avoid this behavior, or any alternative way to store more than 255 characters of text in a field?</p>