title: Microsoft Access Queries Too Many Fields
body: <p>I am dealing with approximately one dozen MS access tables that are all linked into a single database file. </p>
  
  <p>Occasionally I would like to be able to get the union of these tables to generate a complete dataset. My attempts to do this so far result in a too many fields defined error. </p>
  
  <p>Is there a way for me to do this using Microsoft access (I can use 2007 or 2010 versions)?  If not, any other suggestions on how this could be achieved would be greatly appreciated.</p>