title: MSAccess - Measure Actual Record Width (characters)?
body: <p>I am assisting to manage a data resource sitting on a SQL server (1.3M+ records, 125 Columns).  The data model is fixed in its current state, though a handful of columns were added in the past month.</p>
  
  <p>I have a DB app that copies a subset records from the primary table into a local table to let users efficiently review/edit, then write back the updated records to the server.  Been working well since 2013. Typical subset is 3K to 10K records.</p>
  
  <pre><code>SELECT dbo_TblMatchedTb.* INTO TblMatchedTb
     FROM dbo_TblMatchedTb
     WHERE (((dbo_TblMatchedTb.INVID)=11339));
  </code></pre>
  
  <p>This week, while creating the local "copy", I saw an error for the first time:</p>
  
  <pre><code>"Record Too Large - err 3047"  
  </code></pre>
  
  <p>Inspecting the dataset produced via the statement above (in a CSV export), I found 7 records MUCH longer than average.  These records were 2087 chars wide, vs 1500 chars ave (including the CSV commas)</p>
  
  <p>Via a bit of manual iteration, I was able to copy over the records when the max record width was shortened to &lt; 1907 chars.</p>
  
  <p><strong>Question:</strong></p>
  
  <p>Is there an efficient method/query to measure the current total record width in the local table described above?  (3K to 10K records, 125 columns).  If I can ID records approaching some limit, I can TRIM several candidate data values (i.e.,from 255 to 100 char).  </p>
  
  <p>I can't touch the schema, but I can conditionally shorten some of the less than critical data values.</p>
  
  <p>Any ideas?</p>