title: Create a check constraint in access and/or DAO
body: <p>I am trying to create a check constraint on an access (jet?) table.</p>
  
  <p>So, I open the .mdb file with access, go into queries->create query in design view,
  type esc, then menu->view->query and finally type</p>
  
  <p>create table X (
    a number,
    check (a > 20)
  )</p>
  
  <p>but access thinks that I have a "syntax error in field definition". However, I don't think so. Therefore my question: is it possible to create a check constraint with access. If so: how.</p>
  
  <p>Additionally, I'd like to create the constraint with dao/vba, not on the GUI. Is that possible?</p>
  
  <p>And lastly, on a slightly related note: how do you enter sql statements into access. I can't imagine that I have to use the queries->design view->query->view route in order to do that. I am used to Oracle's SQL*Plus, which I like very much, and I'd hope there's something similar for access as well.</p>
  
  <p>Thanks for any input
  Rene</p>