title: Adding a comment to a database field using JET
body: <p>I am working on a script to manage a small Access database online using the Jet engine in PHP. One thing I am having trouble doing is adding a comment to a field. This is quite easy using Access directly, but I can't figure out to do it programatically through an SQL statement or something similar. Any ideas? Thanks!</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>I generally use MySQL, but Access provides a few benefits from time to time for smaller databases. Mostly, I can download and email them to people to use for whatever purpose they require.</p>
  
  <p>I store timestamps as a <code>long int</code> rather than one of the built in types because it is easier to work with in PHP that way, and a lot easier to run a query against. I want to add a simple comment next to these timestamp fields that simply says something like <code>Unix Timestamp</code> so both the script and user know this as a timestamp rather than simply a number. I already know how to read comments, but can't seem to figure out how to write them when adding a new field.</p>
  
  <p>I am using ADODB and Jet to interact with the database like so:</p>
  
  <pre><code>$conn = new COM('ADODB.Connection');
  $conn-&gt;Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={$db};Mode=ReadWrite;");
  </code></pre>