title: Get contents of laccdb file through VBA
body: <p>I want to be able to view the contents of my access database's laccdb file through VBA so I can use it to alert users (through a button) who else is in the database.</p>
  
  <p><strong>I specifically don't want to use a 3rd Party tool</strong>. I have tried using:</p>
  
  <pre><code>Set ts = fso.OpenTextFile(strFile, ForReading)
  strContents = ts.ReadAll
  </code></pre>
  
  <p>This works fine if only 1 user is in the database. But for multiple users it gets confused by the presumably non-ASCII characters and goes into this kind of thing after one entry:</p>
  
  <p><a href="https://i.stack.imgur.com/B4zfM.png" rel="noreferrer"><img src="https://i.stack.imgur.com/B4zfM.png" alt="complete gibberish"></a></p>
  
  <p>Does anyone have any suggestions? It's fine if I just open the file in Notepad++...</p>
  
  <hr>
  
  <p>Code eventually used is as follows (I didn't need the title and have removed some code not being used):</p>
  
  <pre><code>Sub ShowUserRosterMultipleUsers()
  Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
  
  cn.Provider = "Microsoft.ACE.OLEDB.12.0"
  cn.Open "Data Source=" &amp; CurrentDb.Name
  
  Set rs = cn.OpenSchema(adSchemaProviderSpecific, , "{947bb102-5d43-11d1-bdbf-00c04fb92675}")
  While Not rs.EOF
      Debug.Print rs.Fields(0)
      rs.MoveNext
  Wend
  
  End Sub
  </code></pre>