title: MS Access: Method 'open' of object '_Recordset' failed
body: <p>The code I am using:</p>
  
  <pre><code>Dim rs As New ADODB.Recordset
  
  rs.Open "select * from QueryName", CurrentProject.Connection, adOpenDynamic, adLockReadOnly
  </code></pre>
  
  <p>Why in the blazes is this returning an open error? The query itself is totally fine.</p>
  
  <p>The query, btw:</p>
  
  <pre><code>SELECT DISTINCT Zone.Office, ledger.representative
  FROM ledger LEFT JOIN [Zone] ON ledger.branch = Zone.app_office
  WHERE (((Zone.Office)&lt;&gt;"" And (Zone.Office) Is Not Null) AND ((ledger.representative)&lt;&gt;"" And (ledger.representative) Is Not Null))
  
  UNION SELECT DISTINCT Zone.Office, ClientList.representative
  FROM ClientList LEFT JOIN [Zone] ON ClientList.branch = Zone.app_office
  WHERE (((Zone.Office)&lt;&gt;"" And (Zone.Office) Is Not Null) AND ((ClientList.representative)&lt;&gt;"" And (ClientList.representative) Is Not Null))
  
  UNION SELECT DISTINCT Zone.Office, ghs.representative
  FROM ghs LEFT JOIN [Zone] ON ghs.branch = Zone.app_office
  WHERE (((Zone.Office)&lt;&gt;"" And (Zone.Office) Is Not Null) AND ((ghs.representative)&lt;&gt;"" And (ghs.representative) Is Not Null))
  
  UNION SELECT DISTINCT Zone.Office, Prospects.representative
  FROM Prospects LEFT JOIN [Zone] ON Prospects.branch = Zone.app_office
  WHERE (((Zone.Office)&lt;&gt;"" And (Zone.Office) Is Not Null) AND ((Prospects.representative)&lt;&gt;"" And (Prospects.representative) Is Not Null))
  </code></pre>