SQL Server & Hyperlinks

R

Radar069

have an Access 2000 database which has been upsized to SQL Server. In the
database there are various tables with Hyperlinks to Documents, This is not
supported in SQL Server how can we recreate the links?


Thanks in advance
 
B

Brendan Reynolds

Store the URL in a nvarchar field, and either set the IsHyperlink property
of the form control bound to the field to Yes, or use the FollowHyperlink
method in code, e.g. ...

Private Sub TestURL_DblClick(Cancel As Integer)

Application.FollowHyperlink Me.TestURL

End Sub
 
Top