title: How to check Table exist in access database or not?
body: <p>How to check table exist or not?</p>
  
  <p>USING VB 6.0 AND ACCESS 2003</p>
  
  <p>My code.</p>
  
  <pre><code>Cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &amp; App.Path &amp; "\iTDC-ACS.MDB"
  Cn.Open
  
  cmdCardEvent.ActiveConnection = Cn
  cmd.ActiveConnection = Cn
  
  cmdcardevent1.ActiveConnection = Cn
  cmd.ActiveConnection = Cn
  
  cmd.CommandText = "DROP TABLE tmp_cardevent"
  cmd.Execute
  
  cmd.CommandText = "drop table tmp_MOI"
  cmd.Execute
  </code></pre>
  
  <p>Here I want to check whether table exist then drop table the else no need.</p>
  
  <p>How to check table exist or not?</p>
  
  <p>Need VB 6 code Help?</p>