How to insert hyperlink into access database via sql?

Question

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.

Fionnuala · Accepted Answer · 2010-06-07 19:30:52Z

5

I do not like hyperlink fields they are inconvenient and difficult to edit. It is much easier to use a text or memo field and use followhyperlink in the code for your form. That being said, the format for a hyperlink is:

DisplayPart#hyperlinkpart#

So

StackOverflow#http://stackoverflow.com#

answered Jun 7, 2010 at 19:30

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CodeFusionMobile Over a year ago

I need the link to be functional in datasheet view. Otherwise I would just put it in the VBA click event. The hyperlink formating you listed is correct though.

Collectives™ on Stack Overflow

How to insert hyperlink into access database via sql?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related