title: vb6 recordset sql query
body: <p>How to use append query in vb6 with access db having a password? The following is giving an error.</p>
  
  <pre><code>dim s as string
  s="insert into patientprofile(crno) select patientprofile.crno from 'd:\liverrecord.mdb' &amp; 'Jet OLEDB:Database Password=liver'"
  </code></pre>