title: MS Access 2010: "Cannot open any more databases."
body: <p>While struggling with a single legacy MS Access application I faced this weird error:</p>
  
  <pre><code>Cannot open any more databases.
  </code></pre>
  
  <p>The application makes extensive use of <code>UNION</code> sql statements. So this seems to cause access hitting the limit of 2048 open tables. Any other chance than getting rid of these unions?</p>