How to insert hyperlink into access database via sql?

Posted by CSharperWithJava on Stack Overflow See other posts from Stack Overflow or by CSharperWithJava
Published on 2010-06-07T19:05:43Z Indexed on 2010/06/07 19:12 UTC
Read the original article Hit count: 270

Filed under:
|
|
|
|

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.

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.

How can I make the value a functional hyperlink? I'd think that the hyperlink data type would actually create hyperlinks.

I'm using Access 2002 SP3.

© Stack Overflow or respective owner

Related posts about sql

Related posts about database