title: ADODB Recordset cannot get whole multivalued field from Access
body: <p>I have a problem with one project in my work. I have a database on Sharepoint. It's hooked into .accdb file (Access 2007/2010). So far, I used ADODB Connection with standard ConnectionString (only Provider - ACEDB 12.0).</p>
  
  <p>When I try to get data from one of multivalued field from database the recordset is empty for this column. Example:</p>
  
  <p>I have to get few columns: ID, Location, Name, People (MVF), Trainers (MVF).</p>
  
  <p>When single record in People column has MORE than 3-4 values - the recordset for this column is empty. If there's less than 3-4 values i'm getting semicolon-separated values (Even a LEFT JOIN statement to get the source data of MVF doesn't make any difference)</p>
  
  <p>I'm working on Excel - the End-user uses ONLY Excel.</p>
  
  <p>When I watch a Recordset - it has empty values when the people's values should be placed - Basing on this I think the problem is caused by type of connection or something. I've tried also DAO connection - no positive results.</p>
  
  <p>I've also tried to make a temporary database in .accdb file only to execute SQL (INSERT INTO tmpDB SELECT People FROM inputDB; -it's a pseudo-code, the syntax is good) And then I get "Cannot execute INSERT INTO for multivalued field".</p>
  
  <p>I know, that the MVF is not recommended to use, but it's a SharePoint DB, and my role is only to get data from db to Excel.</p>
  
  <p><strong>Update</strong></p>
  
  <p>I tried to use the ODBC driver ...</p>
  
  <pre><code>objConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=" &amp; myconn &amp; ";Uid=Admin;Pwd=;"
  </code></pre>
  
  <p>... instead of the OLEDB provider ...</p>
  
  <pre><code>objConn.Provider = "Microsoft.ACE.OLEDB.12.0"
  objConn.Open myconn
  </code></pre>
  
  <p>... but now the MVF are always empty.</p>