title: insert into if not exists ms-access
body: <ul>
  <li>Using MS Access 2019</li>
  <li>table_a(id,name)
  
  <h1>doesn't work</h1></li>
  </ul>
  
  <pre><code>INSERT INTO table_a ( name ) VALUES (@name_)
  WHERE NOT EXISTS (select name from table_a where name=@name_);
  </code></pre>
  
  <blockquote>
    <p>error : Query input must contain at least one table or query</p>
  </blockquote>
  
  <p><br>
  and this doesn't work</p>
  
  <pre><code>INSERT INTO table ( name ) select @name_
  WHERE NOT EXISTS (select name from table where name=@name_);
  </code></pre>