title: Error 80004005 when executing query in ADODB (VBA, Excel and Access 2010)
body: <p>I have a problem which I can not get my head around. I have an Access database where I am trying to create a set of queries in by using VBA in Excel by use of ADODB.</p>
  
  <p>I have several queries that are successfully created, ie. the one below here. The second will however not work. If I copy the query manually to the access database (From SELECT and forward) and save is as "DK_Teledata_1" it works perfect</p>
  
  <pre><code>CREATE PROCEDURE DK_Aktiviteter_Union_1 AS SELECT DK_Aktivitet.År FROM DK_Aktivitet;
  </code></pre>
  
  <p>And the one that does not work</p>
  
  <pre><code>CREATE PROCEDURE DK_Teledata_1 AS SELECT DK_Teledata.Dato FROM DK_Teledata INNER JOIN Time_Intervals ON DK_Teledata.Interval = Time_Intervals.Time_Interval;
  </code></pre>
  
  <p>The following queries with the same data are created without any problems:</p>
  
  <pre><code>CREATE PROCEDURE DK_Teledata_1 AS SELECT * FROM DK_Teledata;
  CREATE PROCEDURE DK_Teledata_1 AS SELECT * FROM Time_Intervals;
  CREATE PROCEDURE DK_Teledata_1 AS SELECT * FROM Time_Intervals, DK_Teledata;
  </code></pre>
  
  <p>As soon as I create the join or use a "WHERE DK_Teledata.Interval = Time_Intervals.Time_Interval" it fails.</p>
  
  <p>The fields Intervals and Time_Intervals are both Text fields with the same length and properties.</p>
  
  <p>Using Excel 2010, accdb database file and "Microsoft.ACE.OLEDB.12.0" provider string.</p>