title: Record is too large MS Access runtime error
body: <p>I have an abnormally large table for one of my applications in MS Access. It violently breaks some rules of normalization, but is otherwise fine for this small application. It has ~100 fields(columns). I have read the <a href="http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx" rel="nofollow">limitation specifications here</a>
  but can't see where I violate any of these. Most of the fields are text fields, and range from a couple words to a couple of sentences. My questions are:</p>
  
  <ol>
  <li><p>Is there a way to get a more descriptive error than "record is too large", so that I can determine how to make it smaller?</p></li>
  <li><p>Would changing my 'text' fields to 'memo' fields decrease the size of my record?</p></li>
  </ol>
  
  <p>At first glance, of all of the specifications potentially violated, this <strong>:Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes :: 4,000</strong><br>
  appears to be the most likely culprit.</p>
  
  <ol start="3">
  <li><p>Would this violation potentially give the "record is too large" runtime error(while filling out a form). </p></li>
  <li><p>Would setting the UnicodeCompression property to 'no' positively or negatively impact the performance?</p></li>
  </ol>