title: Creating a BLOB in an Access database
body: <p>Using VB.Net I am trying to create an Access table with a BLOB field. I have successfully created the table using Access itself and declaring the field as "Ole Object".  However, for customers, I must create the table programmatically.  I have tried:</p>
  
  <pre><code>create table BLOBTABLE (BlobFileName TEXT(255)   NOT NULL ,  BlobData LongVarBinary )
  </code></pre>
  
  <p>and get a table create error.  In my ConnectionString I'm using "Provider=Microsoft.Jet.OLEDB.4.0".  I'm guessing it doesn't like the LongVarBinary datatype, but I'm not sure what else to use. Anybody know how to do this?</p>