title: How to insert hyperlink into access database via sql?
body: <p>I have a fairly simple MS Access Database that contains some metadata about a bunch of documents and a hyperlink field that links to the document on our network drive.</p>
  
  <p>However, when I use a SQL INSERT statement to populate the hyperlink field, the value I give it only becomes the display text, not the actual link.</p>
  
  <p>How can I make the value a functional hyperlink?  I'd think that the hyperlink data type would actually create hyperlinks.</p>
  
  <p>I'm using Access 2002 SP3.</p>