title: Select into table in another database that is password protected?
body: <p>In Microsoft Access 2003 and Visual Basic 6 I'm trying to copy a table to another access database that is password protected like this...</p>
  
  <pre><code>Select * INTO table2 IN 'database2.mdb' [;Password=TestPass] From table1
  </code></pre>
  
  <p>It fails with error : <strong>Not a valid password</strong></p>
  
  <p>Does the Select INTO format not accept the password with the mdb, and the password has to be in a connection string?  If not, how do you reference a different connection string/database?</p>
  
  <p>thanks</p>