title: Automatically Generate SQL from existing MS Access table
body: <p>I've just designed a large database by playing around in MS Access. Now that I'm happy with the design, I need to be able to generate this same database (tables, relationships, etc.) from code.</p>
  
  <p>Rather than hand-writing the SQL CREATE statements (which will be long, tedious, and error-prone process), I was wondering whether there was a shortcut. I seem to recall from my limited exposure to MySql that I was able to export an entire database as an SQL statement that can then be run in order to regenerate that database. </p>
  
  <p>Do you know of a way to do this in MS Access, either through the GUI, or programmatically? </p>