Results 1 to 4 of 4
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313

    How to Define a Hyperlink Data Type in SQL Server

    I currently have an Access backend with some fields defined as Hyperlink. This lets me click on the field from an Access form to open the web site, email address, pdf file, etc. I plan to move the backend to a 2008 R2 SQL Server where "Hyperlink" isn't a valid data type. After I do that, how do I edit the field (Access provides a right-click, Hyperlink, Edit method) and how do I just click on it to open the file.



    Thanks, Eddie

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I just use a plain text field, and FollowHyperlink to open the file/site.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    JohnnyCash's Avatar
    JohnnyCash is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2012
    Location
    Artesia, CA
    Posts
    3
    I just want to know ,whether there is any way to store 'hyperlink' in sql Table as in MS Access.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    From

    http://blogs.msdn.com/b/ssma/archive...nversions.aspx

    The Access Hyperlink data type stores three pieces of datažthe URL, display text, and a screen tip. This data is stored in a Memo column delimited by pound signs, with a special attribute indicating that the column is a hyperlink. Hyperlinks only work in the Access UI with native Jet or ACE tables, not with SQL Server data.


    The Access user interface detects these columns and handles them differently from regular Memo fields. However, when you migrate the data to SQL Server, the special attribute is gone and all that remains is the pound-sign-delimited data. You will need to research alternative solutions in your client application if you need to duplicate the behavior of Hyperlinks in your client application.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-15-2012, 11:40 AM
  2. Hyperlink Problem in SQL SERVER!!
    By Rxp in forum Access
    Replies: 0
    Last Post: 05-03-2012, 07:48 PM
  3. Error:User-Define type not defined
    By A S MANN in forum Programming
    Replies: 8
    Last Post: 11-05-2011, 04:31 AM
  4. Access and SQL Server data type problem
    By rayc in forum Access
    Replies: 1
    Last Post: 09-10-2010, 07:27 PM
  5. Replies: 2
    Last Post: 03-18-2010, 08:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums