title: What is the MS Access SQL syntax to create a field of type Hyperlink?
body: <p>I'm working on a C# project that uses System.Data.OleDb.OleDbCommand class to create and alter tables in an MS Access DB.  I generate the SQL statement, pass it to the object, then call the ExecuteNonQuery function.  I was able to figure out the proper MS Access SQL syntax to create columns of the following Access data types:</p>
  
  <pre>
  AutoNumber: ALTER TABLE <i>table-name</i> ADD COLUMN <i>column-name</i> COUNTER|AUTOINCREMENT
  Currency:   ALTER TABLE <i>table-name</i> ADD COLUMN <i>column-name</i> MONEY
  Date/Time:  ALTER TABLE <i>table-name</i> ADD COLUMN <i>column-name</i> DATE
  Memo:       ALTER TABLE <i>table-name</i> ADD COLUMN <i>column-name</i> MEMO|TEXT
  Number:     ALTER TABLE <i>table-name</i> ADD COLUMN <i>column-name</i> NUMBER
  OLE Object: ALTER TABLE <i>table-name</i> ADD COLUMN <i>column-name</i> OLEOBJECT
  Text:       ALTER TABLE <i>table-name</i> ADD COLUMN <i>column-name</i> CHARACTER
  Yes/No:     ALTER TABLE <i>table-name</i> ADD COLUMN <i>column-name</i> BIT
  </pre>
  
  <p>The only type I haven't figured out how to create is Hyperlink.  Does anyone know the syntax for that one? </p>