title: Syntax Error in From clause - VB6
body: <p>Having a problem getting the above Error Message.
  Can anyone assist please ?</p>
  
  <pre><code>Dim cn As New ADODB.Connection 
  Dim cmd As New ADODB.Command 
  Dim RS As New ADODB.Recordset 
  Dim RS2 As New ADODB.Recordset
  
  Set cn = New ADODB.Connection
  Call cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;" &amp; "Data Source=" &amp; TheServer &amp;   
            FileTypeOld &amp; ";" &amp; "Jet OLEDB:Database Password=12345678;")
  
  If cn.State = 0 Then cn.Open
  Set cmd.ActiveConnection = cn
  cmd.CommandText = "SELECT * FROM mov"
  cmd.CommandType = adCmdTable
  Set RS = cmd.Execute
  </code></pre>