Hyperlink data fields in MS Access 97 do not import correctly into MS SQL Server. The hyperlink becomes an ntext field but caused errors when trying to access the records through MS Access forms linked to the SQL Server database tables. These ntext fileds were converted to varchar so that the records could at least be read, however, these fields are still text with an underline and not a hypertext link as they were originally in MS Access. Is there a way to have these fields behave as hyperlinks?
