title: Constant 2 dimensional array Access VBA
body: <p>Is it possible to create a constant two dimensional array in VBA using access only? 
  I have Tried:</p>
  
  <pre><code>Const s1 As String = [{"a","b","c";"1","2","3"}]
  </code></pre>
  
  <p>from <a href="https://stackoverflow.com/questions/24584088/how-to-initialize-a-multidimensional-array-variable-in-vba-for-excel">How to initialize a multidimensional array variable in vba for excel</a> and</p>
  
  <pre><code>Const s2 as variant = array(array("a","b","c"),array("1","2","3"))
  </code></pre>
  
  <p>But neither work. I checked to see if they work as regular declarations.  </p>
  
  <pre><code>Dim s1 As String = [{"a","b","c";"1","2","3"}]
  </code></pre>
  
  <p>fails, and it seems to be because i am not using Excel.</p>
  
  <pre><code>dim s2 as variant = array(array("a","b","c"),array("1","2","3")) 
  </code></pre>
  
  <p>succeeds.</p>