title: Open recordset in Access 2003/2007
body: <p>It's been years since I've worked in Access code and it is making me certifiably insane.</p>
  
  <p>I just don't remember anything and all I want to do is open a recordset in code and nothing I've found online or any permutation of code I've tried works.</p>
  
  <p>The short of it:</p>
  
  <pre><code>Dim rsSystem As Recordset
  Dim sSQL As String
  
  sSQL = "SELECT * FROM Table"
  Set rsSystem = CurrentDB.OpenRecordset(sSQL)
  </code></pre>
  
  <p>What in the holy hell am I missing?</p>
  
  <p>Thanks in advance.</p>