SQL Hyperlink Conversion
Posted on 2003-11-10
We are converting our Access back-end to SQL. The hyperlink data types are getting converted to text data type. Is there any way to keep the hyperlink capability in SQL? I would like my Access Front-end to work the way it does now using the Access back-end. I have many forms that show the hyperlink data with a blue line under it and the user can hyperlink to the document by clicking on the hyperline. The user can also right click on a hyperlink and is offered an edit menu. I would like to keep that functionallity. I would like to make the change in SQL not in my Access Front-end if possible.